ByteScout Spreadsheet SDK – VBScript – Save As PDF

Home
/
Articles
/
ByteScout Spreadsheet SDK – VBScript – Save As PDF

printable version:
ByteScout-Spreadsheet-SDK-VBScript-Save-As-PDF.pdf

How to save as PDF in VBScript with ByteScout Spreadsheet SDK

Tutorial on how to save as PDF in VBScript

ByteScout tutorials are designed to explain the code for both VBScript beginners and advanced programmers. What is ByteScout Spreadsheet SDK? It is the SDK to create, read, modify and calculate spreadsheets. Formula calculations are supported, import and export to and from JSON, CSV, XML, databases, arrays. It can help you to save as PDF in your VBScript application.

VBScript code samples for VBScript developers help to speed up coding of your application when using ByteScout Spreadsheet SDK. In your VBScript project or application you may simply copy & paste the code and then run your app! Enjoy writing a code with ready-to-use sample VBScript codes.

Trial version of ByteScout Spreadsheet SDK can be downloaded for free from our website. It also includes source code samples for VBScript and other programming languages.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

Save As PDF.vbs

      Set document = CreateObject("Bytescout.Spreadsheet.Spreadsheet")

document.RegistrationName = "demo"
document.RegistrationKey = "demo"

 ' Add new worksheet
Set worksheet = document.Workbook.Worksheets.Add("HelloWorld")

' add a cell 
Set cell = worksheet.Cell(1, 1)
cell.Value = "Testing, Testing, Testing, Testing..."

' Save spreadsheet as PDF file:

' Save PDF with automatic page size...
document.SaveAsPDF "autosized.pdf"
' ... or save PDF with fixed page size
document.SaveAsPDF_2 "fixedsize.pdf", False ' the second parameter disables autosizing 

' close Spreadsheet
Set document = Nothing