change printer settings

[bensonsearch]

Hi All,

Is there a way to change printer settings within vba code?

for example change it from printing black and white to printing colour?

cheers

 

[Smitty]

Sure, but your best bet is to record a macro changing your print settings. That way VBA will catch those things that your particular printer can/can't do (since they do talk to each other).

Post back what you get and someone can clean it up for you.

 

[bensonsearch]

Hi,
Thanx for the quick reply.
For some reason when im recording it wont do anything. all i can get is if i select stuff. If i change settings nothing, only:
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"