Navigation
i want to export 1 tag form wincc flexible 2008 to excel, can you help me?
Created by: hoaild22@gmail.com at: 7/8/2010 6:59 AM (1 Replies)
Rating 
Thanks 0
2 Entries
| 7/8/2010 6:59 AM | |
Joined: 7/6/2010 Last visit: 12/17/2025 Posts: 84 Rating:
|
why do i write code down into script wincc flexible so have error at : Set Excel = CreateObject("Excel.Application"). i want to export 1 tag form wincc flexible 2008 to excel, can you help me, and give me code script. thank you very much this code run wincc 7 ok but wincc flexible 2008 error. ------------@------------------------------------------------------------- Dim Excel Dim XLS_File Dim SheetName Dim V(2) V(1) = HMIRuntime.Tags("File_name").Read V(2) = HMIRuntime.Tags("Sheet_name").Read XLS_File = V(1) SheetName = V(2) Set Excel = CreateObject("Excel.Application") Excel.Workbooks.Add Excel.Worksheets(1).Name = SheetName Excel.Worksheets(SheetName).range("A1") = "test by ddg" Excel.Worksheets(1).SaveAs (XLS_File) Excel.Quit Set Excel = Nothing Splitted from Data Exchange Between WinCC 7.0 & Excel. |
Last edited by: O_Moderator at: 7/8/2010 10:37 AMnew subject after splitting |
|
| 7/8/2010 3:03 PM | |
Joined: 5/28/2008 Last visit: 9/1/2025 Posts: 901 Rating:
|
Hello mencaulong, in wincc flexible you only can use VBS and no VBA. But you can export the tag or creating historical data in runtime. http://support.automation.siemens.com/WW/view/de/26190515 regards Manfred |
Follow us on