Read Fields from Comma Delimited File 1

[dmon000]

Is it possible to read the contents of the last two fields of the first line of a comma delimited text file? My 25 pounds of books have very little to say on using vba to read a text file.

Thanks!!

 

[maxhugen]

Look up the VBA help on 'Open' which will open a file, and then 'Input#'.

Once you've 'read' the line into a string variable, you'll need to parse it, using the comma as the delimiter.

Max Hugen

http://www.hugen.com.au

Australia

 

[dmon000]

Is it possible to import just the first line of comma delimited text file with vba?

 

[Remou]

MaxHugen explained how to do this so why post again in thread705-1382916?. You can also use FileSystemObject to read a textfile and you can link a CSV and use a make table query.

 

[dmon000]

Sorry about the redundant post. And Thanks again to Remou for the info about linking CSV files.