» Change the default printer using VBA in Microsoft Excel
VBA macro tip contributed by Erlandsen Data Consulting offering Microsoft Excel Application development, template customization, support and training solutions
CATEGORY - Printing in VBA
VERSION - All Microsoft Excel Versions
This is done by changing the property Application.ActivePrinter :
Sub PrintToAnotherPrinter()
Dim STDprinter As String
STDprinter = Application.ActivePrinter
Application.ActivePrinter = "microsoft fax on fax:"
' change printer
ActiveSheet.PrintOut
' prints the active sheet
Application.ActivePrinter = STDprinter
' change back to standard printer
End Sub
Book Store:
Recommended Books:
- The One Page Business Plan: Start With a Vision, Build a Company!
- Keys to Reading an Annual Report (Barron's Business Keys)
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- The Guide to Understanding Financial Statements
- Finance and Accounting for Nonfinancial Managers
- Special Edition Using Microsoft Word 2002
No comments have been submitted.

