Programmatically Saving a PRN FIle

[MJG]

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

 

[Andrew Poulsom]

Use the format xlTextPrinter.

 

[MJG]

Thank you so much for the tip. I just looked in the help file and this option is not in the list of formats. Where did you find documentation on this?

 

[Andrew Poulsom]

In VBE Help look at the SaveAs method and click the FileFormat property link.