Exporttofile now prompting for Printer setup

[mfleuette]

To all, a search did not turn up an answer for this, so I am hoping someone can shed some light on the problem.

I am using the code below to export a workbook to a PDF file:

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFile, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False

It has been working fine, generating a file and continuing without interruption, but now when it gets to this statement, it pops up a printer setting dialog box, stopping the loop

Does anyone have any thoughts on why the dialog box is popping up and how to suppress it or prevent it from popping up?

Thank you in advance for your help.

 

[mfleuette]

Anyone ever run into a problem exporting to PDF?

To all, a search did not turn up an answer for this, so I am hoping someone can shed some light on the problem.

I am using the code below to export a workbook to a PDF file:

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFile, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False

It has been working fine, generating a file and continuing without interruption, but now when it gets to this statement, it pops up a printer setting dialog box, stopping the loop

Does anyone have any thoughts on why the dialog box is popping up and how to suppress it or prevent it from popping up?

Thank you in advance for your help.