open .txt file
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... |
open .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... |
open .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... |
open .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... |
All times are GMT +1. The time now is 12:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com