ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   printing using a macro (https://www.excelbanter.com/excel-discussion-misc-queries/93896-printing-using-macro.html)

John

printing using a macro
 
Does anybody know a way to use a macro to assign an alternate printer other
than the default printer on a network?
I have a macro in place to print a file, but have to change the default
setting every time before I start using the file. I am tryng to figure out a
program to use macros to accomplish it for me.
--
John

Dave Peterson

printing using a macro
 
What code do you get when you record a macro when you change the printer
manually.

(And remember to change it back, too???)

John wrote:

Does anybody know a way to use a macro to assign an alternate printer other
than the default printer on a network?
I have a macro in place to print a file, but have to change the default
setting every time before I start using the file. I am tryng to figure out a
program to use macros to accomplish it for me.
--
John


--

Dave Peterson


All times are GMT +1. The time now is 02:50 PM.

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