VBA or Macro to select a specific printer profile?

**DanGres** · 02-14-2015, 03:05 AM

Hi all,
Is it possible to select a specific printer profile using VBA or a macro? I send an Excel file by email to multiple users, I would like to print the returns Duplex and stapled. Have done the code, but some returns have the correct profile saved, others go to Default Settings. I have at the moment the Printer Dialog box open automatically so I can manually select the correct Profile, but it would be better automatically.
Thanks for any help or suggestion.
Dan

Excel 2010
Network Printer - Canon

**Brendan_Floyde** · 02-14-2015, 08:50 AM

I'd suggest recording a macro in excel and adjusting the resulting code accordingly. Things like page set up will work, things like staples / duplex are likely to require Windows API call or changing registry settings - this gets quite complicated very quickly. Sendkeys is sometimes used to simplify code but its not a great solution

**DanGres** · 02-14-2015, 02:39 PM

Thanks Brendan,
I had already recorded a macro, but there's no details recorded when I try to change the Profile selection. The page set up seems fine, just when the file is completed, saved and returned by other users, the Printer Profile Returns to default settings rather than the one I saved in the template. I think the user edits, then prints the file on their machine, which doesn't have my Printer profile saved.
Think I'll have to manually select the print Profile via the Dialog box.
Dan