I'm trying to create a program using VBA within excel that will read specific data from a user specified CSV file. I would like the user to browse for and select the CSV file, and once selected, the program imports only the required variables from the file into the program to be used. ideally, this would be done without having to physically open the CSV file. it would just read it. is this something that an amateur VBA programmer could handle? does anyone have any advice or suggestions for me, to point me in the right direction. i am able to create a diolog box to open a CSV file, but that's about it so far.

thanks!