Hi,
I have an excel spreadsheet that I would like to convert to a .txt file. When I try this all of my commas are shown as "," I need to remove the double quote. The file is correct if I convert to a .csv file, but I would like it to have the .txt file extention.
In the first line of the attched file you will see something similar to this.
OUCT1447.6POUFPL4/10/2010 0:004/10/2010 1:00
If I save the attached file as text I would like for every tab to insert a comma so that the line would look like:
OUCT,1447.6,,,,,,POU,FPL,4/21/2010 0:00,4/21/2010 1:00
This file should be named C:\ATC\OUCT_TTC which is a text file.
I am trying to creat a macro to take the attached file, which is a tab in a worksheet I have and automatically save it as C:\ATC\OUCT_TTC. Then I have to upload this file to a website which can only read it as a txt.
I hope this is clear, and thanks for the help.
Joe
I have an excel spreadsheet that I would like to convert to a .txt file. When I try this all of my commas are shown as "," I need to remove the double quote. The file is correct if I convert to a .csv file, but I would like it to have the .txt file extention.
In the first line of the attched file you will see something similar to this.
OUCT1447.6POUFPL4/10/2010 0:004/10/2010 1:00
If I save the attached file as text I would like for every tab to insert a comma so that the line would look like:
OUCT,1447.6,,,,,,POU,FPL,4/21/2010 0:00,4/21/2010 1:00
This file should be named C:\ATC\OUCT_TTC which is a text file.
I am trying to creat a macro to take the attached file, which is a tab in a worksheet I have and automatically save it as C:\ATC\OUCT_TTC. Then I have to upload this file to a website which can only read it as a txt.
I hope this is clear, and thanks for the help.
Joe
Attachments
-
13.5 KB Views: 34