The macro listed below allows changing printers. I can change from MX880 to MX850 but it wil not change back. It says the MX850 is the active printer and do I want to change to MX850. What is wrong with my code.
Please Login or Register to view this content.
Last edited by arlu1201; 09-03-2012 at 04:36 AM.
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Maybe it's just a typo, shouldn't there be a port number: at the end of the printers' names.
The macro works fine for me with my printer names on Excel 2003. This is one of mine: "EPSON SQ-870 (in rete 100) su Ne04:"
Last edited by rollis13; 09-03-2012 at 04:54 PM.
I'm surprised that your code will change the printer at all. In Excel you need to include the port number when changing the active printer Ne0 something usually.
If you have a look in the tips and tutorials forum there's a thread discussing how to get the right port number
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks