Hello,

I got a problem and i dont know the solution anymore. I tried a lot of things, but i can not get it done. I make a simple app for excel, the computers are running in a network. Some PC`s got different printers.

The user can select the printer from the worksheet. I found a macro that tells me the good printername with the good NE number. But when i say application.activeprinter = Variable, it doesnt work. Every time I got an error. (error 1004, method of activeprinter on object doesnt work)

Can someone please help me and tell me whats going wrong...

Please Login or Register  to view this content.
Please Login or Register  to view this content.
Thanks in advance