4/8/2019 8:34 AM | |
Joined: 9/4/2018 Last visit: 9/18/2024 Posts: 60 Rating: (0) |
I'm using WinCC 7.4 SP1, VB Scripting to create Excel file. File is created successfully. Now want to save it as PDF. My Excel version is 2010. I'm using following command for creating PDF, dim l_filename l_filename = "E:\SavedReports\testpage2.xlsx" dim ObjSheet1, ObjExcel, EWB set ObjExcel = createobject("Excel.Application") set EWB = ObjExcel.WorkBooks.Open(l_filename) set objSheet1 = ObjExcel.ActiveWorkBook.Worksheets(Sheet1) ObjSheet1.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:=l_filename, _ OpenAfterPublish:=True, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ Quality:=xlQualityStandard But getting Syntax error in last line. Pls. help ------------------------------------------------------------------------------------------ |
Last edited by: Jen_Moderator at: 4/8/2019 1:13:52 PMNew subject after splitting |
|
4/8/2019 1:16 PM | |
Joined: 6/19/2017 Last visit: 9/6/2024 Posts: 8175 Rating: (172) |
Closed cause question posted twice. The second thread with the subject Excel to PDF converter is published within the conference SIMATIC WinCC (TIA Portal). Best regards Jen_Moderator |
Follow us on