# VBScript Convert XLS file to PDF

**URL:** <https://forum.robusta.ai/t/vbscript-convert-xls-file-to-pdf/108>\
**Category:** FAQ\
**Created:** [April 29, 2022, 1:41pm UTC](https://forum.robusta.ai/t/vbscript-convert-xls-file-to-pdf/108 "2022-04-29T13:41:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ilayda.ipar](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.robusta.ai/ilayda.ipar/32/56_2.png) [@ilayda.ipar](https://forum.robusta.ai/u/ilayda.ipar)\
**Post date:** [April 29, 2022, 1:41pm UTC](https://forum.robusta.ai/t/vbscript-convert-xls-file-to-pdf/108/1 "2022-04-29T13:41:26Z")

</div>

Use VBScript to convert Excel Xls file to PDF.

⬇

```auto
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

 

```