Set Printer name and Setting in Macro

[YuriyBaron]

Hi,

I have a Macro that executes commands and prints right after.
Before I execute the macro, I need to go and change printer and printer settings.
Is there a way to include printer name and settings in the beginning of the macro before everything gets executed?

Printer Name: WestOffice on network1
Printer Properties:
Job Type
Normal Print
Color / Black and White
Color


Thanks,
Yuriy

[Logit]

.

Here is a resource from the Net :

Please Login or Register  to view this content.

This resource has a more descriptive macro and specifies B&W color printing :

https://windowssecrets.com/forums/sh...g-in-vba-macro


From MS: https://msdn.microsoft.com/en-us/vba...property-excel

Please Login or Register  to view this content.

And ... you can always use the MACRO RECORDER while you go through the Print Setup routine. The resulting macro should be at least very close to what you are seeking.

Trust something here works for you.

[YuriyBaron]

Great,

Based on what you wrote, I made this:

Please Login or Register  to view this content.

How would I specify in printer Setting Job Type: Normal Print

Thanks,
Yuriy

[Logit]

.
I am at a loss with this question. I've searched the NET for one hour and cannot locate anything pertaining to Print: Normal. Tried every search term I can think of regarding
the Print Job Type.

This is dangerous (you know what they say about assuming), but I presume if you don't specify a print job type, it should be normal by default ?

[YuriyBaron]

Unfortunately the reason why I need to specify the Job Type is that the default setting is set to "Sample Print" and not "Normal Print".

Do my changes in the code make any sense?

Thanks,
Yuriy