Excel VBA ActiveWindow.SelectedSheets.PrintOu

Registration date
Wednesday April 28, 2010
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.