Hello Ranjit,

You modify this code

Open "test.txt" for Ouput as #1
For L = 1 to 100
Print Cells(L,1).value
Next
Close #1

J a c q u e s

"Ranjit kurian" a écrit dans le
message de ...
Hi

I need a excel macro code to open my existing txt file(test.txt), i have
saved test.txt in c: drive, my macro should open test.txt fiile then it
should copy the Book1.xls data to test.txt file...