Forum Discussion
VBA Programming Assistance
I have been working on the attached spreadsheet creating formulas and now I have wading into the VBA programming...which I have not done since college and didn't do very well then. As I get deepe...
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?