Printer setup via VBA in Excel
Posted
by Gina
on Stack Overflow
See other posts from Stack Overflow
or by Gina
Published on 2010-03-26T20:38:39Z
Indexed on
2010/04/03
2:03 UTC
Read the original article
Hit count: 282
excel-vba
I am trying to assign a cell in Excel for the user to type the printer name where they want the print out to go and then use that value in the
Application.ActivePrinter = (use the cell value)
Even though I have done the programming assigning a name to the cell and using it in a variable it is giving me an error.
I have set my variable as string, text, object and variant already and it's not working.
Do you know what code should I use to be able to do this?
© Stack Overflow or respective owner