VBA print problem

**Aquila** · 03-31-2010, 08:38 PM

Hello,

Following code I use to print out my page on sheet 1. Now I have also a page on sheet 2 i want to print on the back.
Can anyone help me to change the code please, i don't know exactly how to do this.

Please Login or Register  to view this content.

Many thanks
Aquila

**Leith Ross** · 03-31-2010, 09:23 PM

Hello Aquila,

Neither Excel nor VBA has a built-in function to set your printer to "duplex" mode. Sometime ago I looked into how to do this. It requires using the Windows API. Copy all this code into a separate VBA module.

Please Login or Register  to view this content.

Using the Macro

Please Login or Register  to view this content.

**Aquila** · 03-31-2010, 10:18 PM

Thankx Leith for fast reply!

It's clear know, i could search a long time.

**mvel_sky** · 04-01-2010, 01:12 AM

Dear Friend,

Please help me to write VBA code for setting PDF creator as a default printer and PDF creation through that.

Regards
M.Velmurugan

**fredpox** · 04-01-2010, 08:34 AM

Hi there,
@ Leith Ross, I think your code is great!
I tried your code at work but I have some problems to access the printers.
We're on a LAN network and all of our printer have a static IP, I have policies to access all of them since they're in the root of our server. I run the pc as Local Administrator.
I can access and print in all of the printers, but as soon as I run the SetPrinterToDuplex function I get a "Access denied - see the article for more info" message.
Please, can you help me in the process to implement this very useful function?

thanks in advance
P.