Reading data from CSV file

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!

you have to open the file to get the data, but it does not need to display to the user at all
what application are you working in?

vb Code:

open "somefile.csv" for input as 1
     myarr = split(input(lof(1), #1), vbnewline)  ' read whole file into array for processing
close 1