Excel VBA ActiveWindow.SelectedSheets.PrintOu [Closed]

Report
Posts
1
Registration date
Wednesday April 28, 2010
Status
Member
Last seen
April 28, 2010
-
 Suneel -


When I use the following code in an excel vba module: PDFFile = "c:\test.pdf"
ActiveWindow.SelectedSheets.PrintOut copies:=1, PrintToFile:=True, Collate:=True, PrToFileName:=PDFFile

I get the following error msg: "When you create a postcript file you must rely on system fonds and use document fonts. Please go to the printer properties a"Adobe PDF Settings" page and turn off the option "Rely on system fonts only; do not use document fonts".

I do exactly what the error msg says and turn that option off but i still get the same message.

Any help would be greatly appreciated. Thanks

1 reply

Open file, go to File->Print, and then go to Print Properties, and change the settings to fix this issue.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!