Convert Excel file into PDF

[Sanskey]

Hi there,

I'm wondering how to make an PDF file from an Excel file. Basically I want to have an existent Excel file from a Folder converted it into a pdf.

Can someone help me out with the code?

Thanks in advance!

[Marcus Tettmar]

Does your version of Excel let you save to PDF? If so, record a macro inside Excel which does that. Then convert the VBA it produces to VBScript to run inside Macro Scheduler:

http://help.mjtnet.com/article/19-conve ... o-vbscript

Or keep the Excel macro inside Excel and run it with XLRun.

Or just simulate sending the keystrokes to Excel to do a Save As.

[Sanskey]

XLRun worked for me and the macro inside the Excel.

Thank you!