save as PRN
Posted by CWW on September 22, 2000 2:16 PM
I have a .XLS file. It's not anything unusual. It contains 5 or 6 columns ranging from 3 characters to 40 characters.
If I click File, SaveAs, and then select Formatted Text (space delimited .PRN) it saves the file fine putting all of the columns into column A. This is the way I want it.
The problem is, in my macro if I write for it to save as a .PRN file it saves the file as a .PRN but does not move all of the data into a space delimited column A.
Any help with this would be greatly appreciated.