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

How to save CSV as PDF with VB script or make it read only???

Created by: mskrpan1 at: 12/5/2017 3:20 PM (6 Replies)

Rating (0)

Thanks 2

7 Entries

12/5/2017 3:20 PM	Rate (0)
mskrpan1 Posts: 35 Rating: (0)	Hello, i made that my report is saved in csv by VB script, now i want to ask is there any whey to save csv to pdf?? Reason is i want file to be read only when manager comes and put USB inside of panel and transfer csv that csv file cant be edited. File that HMI create when i put in on USB stick is editable but i need it to be uneditable. So if there is any whey to make it read only even like csv it would be great if not is there any oder whey to make it like pdf with script? Thanks in advance!!
mskrpan1 Posts: 35 Rating: (0)
Suggestion To thank Quote Answer

12/6/2017 9:27 AM	Rate (0)
cumulus Posts: 993 Rating: (103)	Hey mskrpan1, have you installed a runtime system on a pc station (WinCC RT Advanced / WinCC Professional) or do you use a panel (like a SIMATIC Comfort Panel)? Which version do you use? With best regards cumulus
cumulus Posts: 993 Rating: (103)
Suggestion To thank Quote Answer

12/6/2017 1:33 PM	Rate (0)
mskrpan1 Posts: 35 Rating: (0)	Hey Cumulus, I have installed WinCC Advanced v14 sp1 and i use HMI TP1500 Comfort.
mskrpan1 Posts: 35 Rating: (0)
Suggestion To thank Quote Answer

12/22/2017 1:41 PM	Rate (0)
cumulus Posts: 993 Rating: (103)	hey maskrpan1, csv to pdf ist not possible,
cumulus Posts: 993 Rating: (103)
Suggestion To thank Quote Answer

1/28/2019 11:56 AM	Rate (0)
AutoGen_9901497 Posts: 2 Rating: (0)	If he is running RT on PC he can do whatever he need with script and app that print file (CSV) To PDF .
AutoGen_9901497 Posts: 2 Rating: (0)
Suggestion To thank Quote Answer

1/29/2019 8:27 AM	Rate (0)
Prof. Frink Platinum Expert Joined: 7/5/2013 Last visit: 12/12/2025 Posts: 3265 Rating: (526)	Hello mskrpan1, one way could be to open the csv (with excel viewer) on the panel and print it by use of the PDF Printer. This is actually only an idea, yet, as I never tried something similar. Another way would be reading the content of the csv to HMI-tags and link those tags to a report. Then you can print the report by use of the PDF Printer. As I don't know the content of the csv resp. the amount of data you need to be printed, maybe this solution might not work. Be aware that printing on the panel (as well as RT Advanced) uses the standard printer of the system. And I guess you cannot change the standard printer on a panel using a script. 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

9/14/2020 7:24 AM	Rate (0)
doloemanuel Advanced Member Joined: 10/13/2013 Last visit: 10/8/2025 Posts: 6 Rating: (2)	Prof. Frink Hello mskrpan1, one way could be to open the csv (with excel viewer) on the panel and print it by use of the PDF Printer. This is actually only an idea, yet, as I never tried something similar. Another way would be reading the content of the csv to HMI-tags and link those tags to a report. Then you can print the report by use of the PDF Printer. As I don't know the content of the csv resp. the amount of data you need to be printed, maybe this solution might not work. Be aware that printing on the panel (as well as RT Advanced) uses the standard printer of the system. And I guess you cannot change the standard printer on a panel using a script. Regards, Frink Hello, dear, I was looking for information for several days and I got a solution. Using Script and PDFCreator can work. This is an example I use. I first send PDF Printer to print and then I make a routine to open PDFCreator which automatically saves the document with the current date. RUNTIME WINCC ADVANCED ON PC..... I show the open and close script: Sub Open_Close_App() Dim sheel Dim kei Dim DelayTime Set sheel = CreateObject("wscript.Shell") sheel.Exec "C:\Program Files\PDFCreator\PDFCreator.exe" Set sheel = Nothing Dim LastTime, StopTime, i DelayTime = 10 StopTime= Now+DelayTime/24/3600 ShowSystemAlarm "Script will be waiting for " & DelayTime & " seconds." Do If Now>LastTime + 0.1/24/3600 Then i = i+1 ShowSystemAlarm "Script is waiting " & Left("....", (i Mod 4) +1) LastTime= Now End If Loop Until Now>=StopTime ShowSystemAlarm "Script resumes working." Set kei = CreateObject("Wscript.Shell") kei.Run "taskkill /im PDFCreator.exe", , True Set kei= Nothing End Sub
	Last edited by: doloemanuel at: 09/14/2020 07:28:12
Suggestion To thank Quote Answer
This contribution was helpful to 2 thankful Users Jen_Moderator Goudaengineer

|

Share this page:

Share this page on...

Related topics by keywords:

TIA WinCC Adv System functions/Scripting

Follow us on