supress displaying of pdf document

[Brian F]

When I come to this command in my vba routine;

ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"

When my default printer is set to print a pdf, it first asks me to save the document as a pdf (that's good) after making the pdf document it then opens the document and shows it to me. I don't want it to open. I want it to save and move on. Is there a way to suppress the document from opening?

 

[Ruddles]

Is there a setting in your PDF driver which tells it whether to just create the file or create and open it?

Failing that, you could let it open and then kill the Adobe Reader process as soon as it appears.

 

[shg]

Instead of using ExecuteExcel4Macro, you could see Help for the ExportAsFixedFormat method

 

[Brian F]

This is a process I do 30 times a day, day after day. Anything other than it not opening will continue to be no fun.

BUT.... on your suggestion I went and poked around and found that there WAS a setting that that told the document to open. I unchecked the box and live is good now.

Thanks for the prod in the right direction.

 

[Brian F]

It turned out there was a setting on Nitro pdf Creator that allowed me to chose to or suppress the document form opening which i was too stupid to look for without some prodding. Thank you for responding to my question. I will research ExportAsFixedFormat so I learn something.