L
Ludo
Hi all,
I'm converting a .xls application with a lot of forms & some modules
to a ADD-IN.
The problems i met while converting are most solved by info i found on
this forum, thank you all a lot for it .
But, i still have a problem.
I need sometimes to change from printer, depending on a single
criteria.
I use in the .xls file following code:
Application.ActivePrinter = ProductionPrinter
This works fine as long as the 'IsAddIn' property is set to false.
If i set this property to True, then i get a fail message.
How can i change the active printer to another printer in a Add-In?
Thanks in advance.
Regards,
Ludo
I'm converting a .xls application with a lot of forms & some modules
to a ADD-IN.
The problems i met while converting are most solved by info i found on
this forum, thank you all a lot for it .
But, i still have a problem.
I need sometimes to change from printer, depending on a single
criteria.
I use in the .xls file following code:
Application.ActivePrinter = ProductionPrinter
This works fine as long as the 'IsAddIn' property is set to false.
If i set this property to True, then i get a fail message.
How can i change the active printer to another printer in a Add-In?
Thanks in advance.
Regards,
Ludo