Link to home
Start Free TrialLog in
Avatar of ITIExperts1

asked on

Publisher Default Printer

User has hundreds of MS Publisher documents, after a recent printer change ALL MS Publisher docs point to Fax printer. Is there any way to get All MS Publisher Docs to print to default printer? I know this can be done on each individual document but there are hundreds of them.
Avatar of omgang
Flag of United States of America image

I can't find any reference on how to discover the specified printer for the open Publisher document; the Publisher.Document object does not seem to expose this.  I also cannot find any setting/option within Publisher where the specific printer is saved.  Yet, as you know, each document can save specific print settings.

You could probably do this via VBA or vbscript.
1) Iterate through all files in a folder(s) looking for filenames ending in .pub
2) Open the file using Publisher automation
3) Change the Printer object to the desired printer
4) Save the doc
Basically, you're simply automating the process of opening each Publisher document, specifying a different printer, and then saving the file with the changes.

How are you with VBA and/or vbscript?
OM Gang

Here's a link describing MS Publisher Printer Object via VBA --
Avatar of omgang
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial