I have about 200 rows of text that need to export to separate text files from excel. I was wondering if anyone knew of a way this would be possible? for some reason when i create a macro to open a new excel file, paste one row and save as a text file, everything shows up with "quotes" around them. also is it possible to have the file name change it self to 1.txt, 2.txt.3.txt for example each time?
Any help/ideas would be appreciated.
Thanks!
Save the file as a .txt file (MSDOS).
You maybe better of using I/O commands rather than copy single row and save as text.
It would help if you could post and example of the data and explain the required output structure
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
paulbk 
Register To Reply
Bookmarks