Forum Discussion
Re: VBA Programming Assistance
When I switched my default printer to the Microsoft XPS Document Writer it worked perfectly...like a perfect charm. That's strange though, I wonder why it does that with a network printer.
1 Reply
Well, Let's see if we can bend it to our will.... I've added a couple lines that gets the current selected printer, changes it to Microsoft XPS Document Writer, goes on to do what it does, and at the end, changes the selected printer back to what it was before. I'm not sure if changing the 'selected' printer in Excel (not the default printer) will do the trick, but I think it's worth a try, right?
