VBScript Convert XLS file to PDF

FAQ
1

Use VBScript to convert Excel Xls file to PDF.

:arrow_down:

Dim objExcel
Dim objWorkBook
fileName ="C:\RobustaWorkspace\out\result.xls"
'Instantiate Excel
Set objExcel = CreateObject("Excel.Application")
'open the xls file
Set objWorkBook = objExcel.Workbooks.Open(fileName)
objWorkBook.ExportAsFixedFormatxlTypePDF,"C:\RobustaWorkspace\out"& objWorkBook.Name & ".pdf"
'close workbook
objWorkBook.Close 'False
'quit excel
'objExcel.Quit

'clean up
'Set objWorkBook = Nothing
'Set objExcel = Nothing