Set Microsoft Excel to print from the PC (being used) default printer? I use different printer at work.?

Question

I have stuff in MS Excel but when I try to print at work something I've done at home it always goes into VB and tries to debug.

Is there any code that I can put into VB that will set the Excel sheet to print from the PC default printer? Bare in mind that it could be two or more different printers, depending on which PC I use at work or at home.

Any help on this would be really appreciated.

Thanks.

Answer 1

I assume you are using a macro and it cannot find the printer specified. One way round is to do all the formatting required by the macro and leave out the print statement then simply use the Excel 'File/Print/Setup' to print the formatted sheet on whatever printer is connected.