Can someone please help me understand why the macro below outputs a PostScript file instead of a PDF file and if there is a way to tweak it such that it does what I expect it to do which is to print a PDF file, not a PostScript file. I would immensenly appreciate any help. Thank you. ThisWorkbook.Sheets(Array("Cover", "Cover Letter", "Proposal Letter", "Testimonials")).Select 'export to PDF ActiveWindow.SelectedSheets.PrintOut _ PrintToFile:=True, _ PrToFileName:="Test Excel Export.pdf", _ ActivePrinter:="Adobe PDF", _ IgnorePrintAreas:=False

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

ActiveWindow.SelectedSheets.PrintOut outputs a PostScript file instead of a PDF file

Thread starter zackii
Start date Aug 16, 2022
Tags

print vba

zackii

New Member

Aug 16, 2022

Can someone please help me understand why the macro below outputs a PostScript file instead of a PDF file and if there is a way to tweak it such that it does what I expect it to do which is to print a PDF file, not a PostScript file. I would immensenly appreciate any help. Thank you.

VBA Code:

ThisWorkbook.Sheets(Array("Cover", "Cover Letter", "Proposal Letter", "Testimonials")).Select

'export to PDF
ActiveWindow.SelectedSheets.PrintOut _
    PrintToFile:=True, _
    PrToFileName:="Test Excel Export.pdf", _
    ActivePrinter:="Adobe PDF", _
    IgnorePrintAreas:=False