Reading 1st row of a CSV file into Array without opening it

[niteshprabhu]

Hi again,

Let say I have a CSV file saved in disk. Now I want to read the 1st row of that file without opening it and import that data in some fixed Array. And I want to do that programmatically using VBA.

Could you please provide some pointer on how to achieve that?

Thanks for your time.

I don't know whether this will help, but you can use start recording macro then go to Data tab and use get data from Text/CSV, this will generate a code which can be used to read from a csv file without opening. However it will paste the data in your worksheet rather than in an array.