The code displayed below will guide you to install an VBScript app to save as pdf with spreadsheet sdk. ByteScout Barcode Suite is the set that includes three different SDK products to generate barcodes, read barcodes and read and write spreadsheets: Barcode SDK, Barcode Reader SDK and Spreadsheet SDK. It can save as pdf with spreadsheet sdk in VBScript.
The SDK samples given below describe how to quickly make your application do save as pdf with spreadsheet sdk in VBScript with the help of ByteScout Barcode Suite. IF you want to implement the functionality, just copy and paste this code for VBScript below into your code editor with your app, compile and run your application. Further improvement of the code will make it more robust.
ByteScout Barcode Suite free trial version is available on our website. VBScript and other programming languages are supported.
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