I am programmatically importing a fixed-width text file using OpenText().
I then manipulate it in terms of formatting and column widths.
I now want to programmatically save the file as a PRN. However, when I use the SaveAs method, I am only offered xlTextMSDOS and xlTextWindows, which both produce a Tab-delimited text file.
How can I programmatically save the worksheet as a fixed-width PRN file?
TIA
I then manipulate it in terms of formatting and column widths.
I now want to programmatically save the file as a PRN. However, when I use the SaveAs method, I am only offered xlTextMSDOS and xlTextWindows, which both produce a Tab-delimited text file.
How can I programmatically save the worksheet as a fixed-width PRN file?
TIA