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.

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.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com
<http://www.ready-reports.com


"J Wait" wrote:

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.