Save an Excel file as PDF, without first opening the Excel file

[jagrenet]

Hello Gurus,

I am looking for a way to basically save a copy of an existing Excel file as a .pdf, without having to open the Excel file to do so.
I currently have the code working ..... and it does save the workbook as a .pdf just fine. I am using -
"Workbooks.Open" and subsequently, .... "
"ExportAsFixedFormat _
Type:=xlTypePDF, _ " (etc.)

As stated, ... this works exactly as it should however, I would like to find a way to convert the file to a .pdf without having to use Workbooks.Open.
Additionally, I would like to keep the original spreadsheet, as it is used on an ongoing monthly basis, with statistics added to it regularly. The .pdf "copy" is used in a report that gets sent to the client each month.

Any ideas how too achieve this ???
Thanks in advance.

 

[jolivanes]

Can you tell us why the workbook should not be opened?

 

[jagrenet]

Can you tell us why the workbook should not be opened?

Primarily because I am looking to speed up the process of creating the client report. This would be one of many steps I am taking to enhance efficiency of my code.
If it can't be done .... that's ok.
But, if it can be done, I would be happy to employ any method that is viable.

Thanks