<div>
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. &nbsp;I also cannot find any setting/option within Publisher where the specific printer is saved. &nbsp;Yet, as you know, each document can save specific print settings.<br />
<br />
You could probably do this via VBA or vbscript.<br />
1) Iterate through all files in a folder(s) looking for filenames ending in .pub<br />
2) Open the file using Publisher automation<br />
3) Change the Printer object to the desired printer<br />
4) Save the doc<br />
Basically, you're simply automating the process of opening each Publisher document, specifying a different printer, and then saving the file with the changes.<br />
<br />
How are you with VBA and/or vbscript?<br />
OM Gang<br />
<br />
<br />
Here's a link describing MS Publisher Printer Object via VBA -- <a href="https://msdn.microsoft.com/en-us/library/office/ff939399.aspx" rel="ugc">https://msdn.microsoft.com/en-us/library/office/ff939399.aspx</a>
</div>


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 -- https://msdn.microsoft.com/en-us/library/office/ff939399.aspx [https://msdn.microsoft.com/en-us/library/office/ff939399.aspx]

<div>
<div class="content wysiwyg-content">
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.
</div>
</div>


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.

Publisher Default Printer

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

A printer is a peripheral which makes a persistent human readable representation of graphics or text on paper or similar physical media. Traditional printers are being used more for special purposes, like printing photographs or artwork, and are no longer a must-have peripheral; 3D printing has become an area of intense interest, allowing the creation of physical objects. An image scanner is a device that optically scans images, printed text, handwriting, or an object, and converts it to a digital image. Hand-held scanners, where the device is moved by hand, have evolved from text scanning "wands" to 3D scanners used for industrial design, reverse engineering, test and measurement, orthotics, gaming and other applications.

Printers and Scanners

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.