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...

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...

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...

Hi Jacques,

Thanks for the code...

The first line of your code is not working for me
"Open "Todays.txt" for Ouput as #1" is in red colour.

Actually i need my test.txt to be opened in one window and in other window
my book1.xls will be opened and it should copy the book1.xls data to test.txt
file..

"Jacques ALARDET" wrote:

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...