Close PDF files
 

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.

Close PDF files
 

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.