ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I create a macro that prints to any default printer (https://www.excelbanter.com/excel-programming/354765-how-do-i-create-macro-prints-any-default-printer.html)

Wanna Learn[_2_]

How do I create a macro that prints to any default printer
 
I need a macro that will print a document from any default printer. Here is
the thing... I have created a form and several people will be using the form.
I want to create a macro so that anyone who receives the document can print
the form by clicking a command button Please help thanks

Gary L Brown

How do I create a macro that prints to any default printer
 
Unless you specifically change the active printer, the macro will print to
the user's active printer.

FYI, You CAN change a printer by using code something like...
Application.ActivePrinter = "hp officejet 6100 series on Ne00:"

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Wanna Learn" wrote:

I need a macro that will print a document from any default printer. Here is
the thing... I have created a form and several people will be using the form.
I want to create a macro so that anyone who receives the document can print
the form by clicking a command button Please help thanks



All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com