Open a file from within macro

[kennywharton]

Iv'e seen it before but didn't make a note of it!
I would like to be able to open a file called Outdoor.csv in the first part
of an existing macro.
Could anyone tell me the code to insert into my macro.

Thanks

Kenny

[dermot]

'Code to read file until finished
Open "c:\temp\outdoor.csv" for input as #1
do while not eof(1)
input #1,x
loop
close

regards

Dermot Balson
Extend Excel with free encryption and web code
http://www.webace.com.au/~balson/InsaneExcel/Default.html

>.
>