Forum Discussion
VBA Programming Assistance
I'm still trying to figure it out. I cannot duplicate it here. My initial searches indicate that it may be due to having a network printer set as your default for your computer, but my default is a network printer, so I'm reluctant to say that is the cause. Just for giggles, though, you may try changing your default printer to Microsoft XPS Document Writer, or something like that to test the theory.
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.
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?