I've recently had my PC built, which has messed up a macro I had:

When I run the macro it says

"When you create a PostScript File you must rely on system fonts and use document fonts. Please go to printer properties, 'Adobe PDF settings' page and turn OFF the option "Rely on system fonts; do not use document fonts"

I've amended this setting but it still fails...here's the bit I think its creating the problem:

Dim route As String
route = "C:\Documents and Settings\amessenger\Desktop\area profiler\" & lsoa & ".ps"

Application.ActivePrinter = "Adobe PDF on Ne02:"
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=4, Copies:=1, ActivePrinter:= _
"Adobe PDF on Ne02:", Collate:=True, prtofilename:=route
link|improve this question
1  
Since you have a new PC, what is the operatiing system? C:\Documents and Settings is not in Vista or Windows 7 so your path may be wrong – datatoo Jul 29 '11 at 20:05
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.