Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

WINCC flexible 2007 Data production script

Created by: Roby at: 6/19/2008 4:35 PM (8 Replies)

Rating (0)

Thanks 0

9 Entries

6/19/2008 4:35 PM	Rate (0)
Roby Silver Member Joined: 4/10/2006 Last visit: 9/1/2023 Posts: 828 Rating: (0)	Hello everybody, in a script I insert this lines: [code] Dim myexc Set myexc = CreateObject("Excel.Sheet") myexc.Application.Visible = True myexc.ActiveSheet.Cells(1,1).Value = "text" myexc.SaveAs "\Storage Card MMC\roby.xls" myexc.Application.Quit Set myexc = Nothing [/code] But when I try to execute this one from one button in Runtime, I have this error: ActiveX component can't create object: 'Excel.Sheet' In some web pages I found this example to export my production data. What can I use for export the real value of my variables? Thank you...
	Setting of my PG M6 Siemens OS: Windows 10 Enterprise 22H2; Intel(R) Core(TM) i7-8850H CPU @ 2.60GHz 2.59 GHz - 32G of RAM TIA: 15.1 Update 8 (i use normally); 16.0 Update 6; 17.0 Update 6
Suggestion To thank Quote Answer

6/19/2008 5:37 PM	Rate (0)
Roby Silver Member Joined: 4/10/2006 Last visit: 9/1/2023 Posts: 828 Rating: (0)	Please help me or say me an example Thank in advance. Roby
	Setting of my PG M6 Siemens OS: Windows 10 Enterprise 22H2; Intel(R) Core(TM) i7-8850H CPU @ 2.60GHz 2.59 GHz - 32G of RAM TIA: 15.1 Update 8 (i use normally); 16.0 Update 6; 17.0 Update 6
Suggestion To thank Quote Answer

6/19/2008 6:32 PM	Rate (0)
Captive Engineer Experienced Member Joined: 1/30/2006 Last visit: 7/26/2023 Posts: 103 Rating: (15)	Roby, Could you provide just a bit more information? What panel model are you using? Or is this project to run on a PC? Thanks, The Captive Engineer

Suggestion To thank Quote Answer

6/20/2008 8:15 AM	Rate (0)
Roby Silver Member Joined: 4/10/2006 Last visit: 9/1/2023 Posts: 828 Rating: (0)	Thanks for reply me. I use MP277 8" key and when I wrote the word createobject the program crash and I receive an error. Then I downloaded and installed the HOT FIX 4 for Wincc Flexible 2007 but I receive the error than I explain in my previous message. Thank you, Roby
	Setting of my PG M6 Siemens OS: Windows 10 Enterprise 22H2; Intel(R) Core(TM) i7-8850H CPU @ 2.60GHz 2.59 GHz - 32G of RAM TIA: 15.1 Update 8 (i use normally); 16.0 Update 6; 17.0 Update 6
Suggestion To thank Quote Answer

6/20/2008 9:11 AM	Rate (0)
The Brain Gold Member Joined: 10/19/2005 Last visit: 11/30/2020 Posts: 1611 Rating: (120)	Hi, i am not a expert for scripting, but i know that the syntax for PC Systems and WinCE Systems are different! So it could be possible that the script could be run on a PC but not under a WinCE System. Did you have looked for sample projects on the customer support sites from Siemens? -> for sample-> http://support.automation.siemens.com/WW/view/de/22726113 There area sample project for PC and WinCE Project (use the german Link!) Maybe this could be helpful for you. regards,

Suggestion To thank Quote Answer

6/20/2008 9:47 AM	Rate (0)
Roby Silver Member Joined: 4/10/2006 Last visit: 9/1/2023 Posts: 828 Rating: (0)	Thank you, it is helpful. I don't understand why I must use FileCtl.FileSystem and not scripting.filesystemobject. However how can I import DLL library? For example Excel DLL. Thanks, regards Roby
	Setting of my PG M6 Siemens OS: Windows 10 Enterprise 22H2; Intel(R) Core(TM) i7-8850H CPU @ 2.60GHz 2.59 GHz - 32G of RAM TIA: 15.1 Update 8 (i use normally); 16.0 Update 6; 17.0 Update 6
Suggestion To thank Quote Answer

6/23/2008 1:56 PM	Rate (0)
The Body Gold Member Joined: 5/13/2008 Last visit: 12/18/2019 Posts: 836 Rating: (70)	To export the current values of the tags to excel, just use SOAP: http://support.automation.siemens.com/WW/view/en/19439822
	mfG / Best regards Roland
Suggestion To thank Quote Answer

6/23/2008 2:44 PM	Rate (0)
Roby Silver Member Joined: 4/10/2006 Last visit: 9/1/2023 Posts: 828 Rating: (0)	Ok thank you. Can you help me about create folder with the FileCtl.filesystem? Please attention because it isn't Scripting.filesystemobject. Thanks in advance. Roby
	Setting of my PG M6 Siemens OS: Windows 10 Enterprise 22H2; Intel(R) Core(TM) i7-8850H CPU @ 2.60GHz 2.59 GHz - 32G of RAM TIA: 15.1 Update 8 (i use normally); 16.0 Update 6; 17.0 Update 6
Suggestion To thank Quote Answer

6/23/2008 3:46 PM	Rate (0)
The Body Gold Member Joined: 5/13/2008 Last visit: 12/18/2019 Posts: 836 Rating: (70)	Pls. see my answer on FileCtl, manage file and folder .
	mfG / Best regards Roland
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on