Close PDF files

[J Wait]

I have several pieces of code that create pdf files by using save as pdf
(ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename: ...)

This automatically opens the pdf files that are created. How can I close
these files?

Thank you for your help.

 

[sebastienm]

Hi,
Have you tried to set the OpenAfterPublish (or DisplayFileAfterPublish ?)
parameter of the ExportAsFixedFormat method to False? Based on the
documention (<http://msdn2.microsoft.com/en-us/library/bb238919.aspx>), that
would prevent the files from being opened and viewed right after the export.