Excel VBA ActiveWindow.SelectedSheets.PrintOu

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


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
Related:

1 response

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