Take a look at these examples:

http://www.erlandsendata.no/english/...hp?t=envbatext

Mike F
"Ranjit kurian" wrote in message
...
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...