mfleuette1
New Member
- Joined
- Sep 18, 2002
- Messages
- 31
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.
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.