Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Wincc & excel

Created by: plcordoba at: 2/26/2007 10:50 AM (3 Replies)

Rating (0)

Thanks 0

4 Entries

2/26/2007 10:50 AM	Rate (0)
plcordoba Regular Member Joined: 1/8/2007 Last visit: 1/5/2024 Posts: 21 Rating: (1)	i want to know like making a wincc internal variable in vbscript function, example: Dim objExcelApp Dim count count = HMIruntime("var1") count.read Set objExcelApp = CreateObject("Excel.Application") objExcelApp.Visible = True objExcelApp.Workbooks.Open "c:\libro1.xls" objExcelApp.Cells( count.value , 3).Value = 67 objExcelApp.ActiveWorkbook.Save objExcelApp.Workbooks.Close objExcelApp.Quit Set objExcelApp = Nothing what is my mistake??? thanks....

Suggestion To thank Quote Answer

2/26/2007 1:07 PM	Rate (0)
Ikkezelf Posts: 1084 Rating: (72)	Hi, I'm not 100% sure, but aren't you forgetting the sheet? with regards, Ikkezelf
Ikkezelf Posts: 1084 Rating: (72)
Suggestion To thank Quote Answer

2/26/2007 3:24 PM	Rate (0)
Big Bear Posts: 27 Rating: (2)	Try it this way: [Code] Dim objExcelApp Dim count count = HMIruntime("var1") count.read Set objExcelApp = CreateObject("Excel.Application") objExcelApp.Visible = True objExcelApp.Workbooks.Open "c:\libro1.xls" Set XLSheet = objExcelApp.ActiveSheet // You need to declare the active sheet XLSheet.Cells( count.value , 3).Value = 67 // References to cells are done on the active sheet objExcelApp.ActiveWorkbook.Save objExcelApp.Workbooks.Close objExcelApp.Quit Set objExcelApp = Nothing [/code]
Big Bear Posts: 27 Rating: (2)
Suggestion To thank Quote Answer

2/27/2007 12:39 PM	Rate (0)
rit03 Silver Member Joined: 6/13/2006 Last visit: 2/11/2023 Posts: 341 Rating: (24)	Hi plcordoba, Instead of writing : count = HMIruntime("var1") please write: Set count = HMIRuntime.Tags("var1") rit03

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on