Skip to Content

SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

SiePortalDeutsch

Search

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

excel to pdf in vb script

Created by: BALAKRISHNAN92 at: 11/1/2022 12:53 PM (6 Replies)

Rating (0)

Thanks 0

7 Entries

11/1/2022 12:53 PM	Rate (0)
BALAKRISHNAN92 Silver Member Joined: 10/21/2013 Last visit: 4/28/2025 Posts: 423 Rating: (28)	hi all, Please share a vb script for converting the xlsx to pdf .

Suggestion To thank Quote Answer

11/2/2022 10:28 AM	Rate (0)
Swarley92 Experienced Member Joined: 8/12/2021 Last visit: 4/11/2025 Posts: 351 Rating: (35)	Hi BALAKRISHNAN92! Maybe this link helps you. It has been discussed in other forum posts. I suggest you search there.
	If this Information really helps, you could use the Rate function Best regards Swarley92
Suggestion To thank Quote Answer

11/4/2022 12:35 PM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 4/28/2025 Posts: 15368 Rating: (1895)	Hello BALAKRISHNAN92 please provide us with some more information: https://support.industry.siemens.com/forum/de/en/posts/what-do-we-need-to-solve-your-problem/141582/?page=0&pageSize=10 Bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer

11/7/2022 8:54 AM	Rate (0)
BALAKRISHNAN92 Silver Member Joined: 10/21/2013 Last visit: 4/28/2025 Posts: 423 Rating: (28)	Hi, Sorry let me eloborate. I have wincc advanced rt v15.1,with sql installed 2014, i was able to log the data in sql and take the report in excel sheet. But my customer wants to save the report in pdf format while exporting from sql.

Suggestion To thank Quote Answer

11/8/2022 7:36 AM	Rate (0)
Prof. Frink Platinum Expert Joined: 7/5/2013 Last visit: 4/28/2025 Posts: 3153 Rating: (524)	Hi, you can check this on e.g. https://learn.microsoft.com/en-us/power-automate/desktop-flows/how-to/convert-excel-pdf-vbscript. Regards, Frink
	Pi is exactly three! All you have to do is think of things which people need but which don’t exist yet.
Suggestion To thank Quote Answer

11/9/2022 6:52 AM	Rate (0)
BALAKRISHNAN92 Silver Member Joined: 10/21/2013 Last visit: 4/28/2025 Posts: 423 Rating: (28)	Hi, Im using the below script. Dim Excel Dim ExcelDoc Set Excel = CreateObject("Excel.Application") 'Open the Document Set ExcelDoc = Excel.Workbooks.open("D:\temp\" & "sm2" & ".xlsX") ShowSystemAlarm "Excel opened" Excel.ActiveSheet.ExportAsFixedFormat 0,"D:\temp\" & "sm2" & ".xlsX",0, 1, 0,,,0 Excel.ActiveWorkbook.Close Excel.Application.Quit If Err.Number <> 0 Then ShowSystemAlarm "Error #" & Err.Number & " " & Err.Description Err.Clear Exit Sub End If Im getting an error Invalid procedure call or argument in line 13

Suggestion To thank Quote Answer

11/11/2022 12:13 PM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 4/28/2025 Posts: 15368 Rating: (1895)	Hello BALAKRISHNAN92 Perhaps you find here some information about the MS Automation Object and its functionalities: https://learn.microsoft.com/en-us/office/vba/api/excel.application(object) Use the 32 Bit version of Excel! Bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on