Question: how to import data from csv to excel vba?
Answer: Activate the worksheet that you want to import the CSV file, then click Data > From Text, see screenshot:
In the Import Text File window, please specify the CSV file that you want to import, see screenshot: