Excel to pdf - how to code default settings?

[cokee33]

Hi,

I'm using vba to automate printing an Excel report to PDF. The code works fine but I need to specify the default settings within the Adobe printer properties (please see screen shot below). Does anyone know how to do this? It seems to reset the default setting to 'Standard' everytime.

Thanks, Cokee33

Screen shot: http://www.flickr.com/photos/54859983@N04/5083432230/

 

[pbornemeier]

You could probably use SendKeys commands like in post #2 of this topic:
http://www.mrexcel.com/forum/showthread.php?t=38658
Post #3 shows part of another, more complex technique that I could not figure how to modify.