PRINTER SET UP IN EXCEL VISUAL BASIC
- by Gina
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?