VBA Change Active Printer

**Nu2Java** · 05-03-2014, 06:41 PM

I was wondering if someone could help me out with what seems like a simple task... I am trying to print a userform to a pdf printer AND to a network printer at the same time, but without success. For some reason the printer does not change to the pdf printer.

The network printer must stay as the default printer. I am using NovaPDF and have it setup to save automatically save with no "Save As" popup. If someone has some fresh code, it would help me out as I think I am going nuts. I have played around with this for 2 days on separate PC's with the same results. I have changed the order of this code more times than I can count just trying to get something different to happen.

Please Login or Register  to view this content.

Note --- I have also used the export to pdf in Excel which does work, but my userform has barcodes on it and this method resizes it just enough where my barcodes do not scan when printed. The output from printing to PDF printer WILL allow the barcodes to scan.

**AlphaFrog** · 05-03-2014, 07:10 PM

As a test, does it print to the PDF printer without switching.

Please Login or Register  to view this content.

I guess I want to know if there is any issue with printing to the PDF printer driver or is there an issue with switching between the two.

**Nu2Java** · 05-03-2014, 07:15 PM

AlphaFrog ... Thanks for the reply.

If I have the network printer as default like I need it to be, I will get two form print outs on the network printer. For some reason it will not switch. If I set manually to the PDF printer, no problem printing as pdf, but it will also not switch to the network printer. I have tried many combos without luck and on different PC's.

**AlphaFrog** · 05-03-2014, 07:26 PM

As best I can tell, the .PrintForm method doesn't use the Application.Printer setting.

This is from the .PrintForm help.

Remarks

The printer used by PrintForm is determined by the operating system's Control Panel settings.

I'm looking into how to set the Control Panel printer from VBA and will post back if I find something.

**Nu2Java** · 05-03-2014, 07:41 PM

Thanks AlphaFrog ... I will continue to play around with this. I really need it to work, anything you find is greatly appreciated.

**AlphaFrog** · 05-03-2014, 08:25 PM

Give this a try. This is uncharted territory for me. So it may or may not work.

Put the Private Declare Function... at the very top of the UserForm code module.

Please Login or Register  to view this content.

**Nu2Java** · 05-03-2014, 08:50 PM

AlphaFrog, you are a genius. This works EXACTLY how I need it to. Thank You very much for your time and help, it is GREATLY appreciated.

**AlphaFrog** · 05-03-2014, 08:54 PM

Cool!

Out of curiosity, what version of Windows are you using? I wasn't sure if this was Windows-version dependent. Apparently not.

**Nu2Java** · 05-03-2014, 09:11 PM

I am using Windows 7 Pro.

**Tracey Steelet** · 05-27-2014, 02:09 AM

Hey, I was having the same problem some time back when I was trying to print to a pdf printer and network printer simultaneously.. I was having the issue of switching between the two.. Then I got the similar solution for it and it really works..

Printer Support