VBA: Printing Excel to PDF issue

[Arturs Jurnieks]

Greetings,

New to VBA, and would appreciate some help on the following:

I am trying to modify an Excel macro to automate printing a bunch of
Excel files to PDF.

My printer settings is set such that in the Adobe PDF Settings tab of
the Printing Preferences, the "View Result in Acrobat" and "Prompt for
PDF Filename" checkboxes are disabled, and this is what I want because
I don't want the dialog box to pop up when I'm printing the files.

However, there are some Excel files that appear to have these settings
saved into them. I have tried recording a macro to disable these
settings but the macro does not appear to record these actions. I
suspect it's because the macro is unable to access the printer object
outside its "jurisdiction".

My problem is that due to certain requirements that I have to meet, I
am not allowed to save the Excel files before I print them to PDF. Is
there any way to access the printer settings from within the VBA macro
so that I can turn off the "View results in Acrobat" and "Prompt for
PDF Filename" settings?

Thank you.

Arturs