Excel VBA ActiveWindow.SelectedSheets.PrintOu

reports Posts 1 Registration date Wednesday April 28, 2010 Status Member Last seen April 28, 2010 - Apr 28, 2010 at 09:13 AM
 Suneel - Jun 11, 2010 at 03:05 AM

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 response

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