SiePortal

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

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

Wincc & excel

2/26/2007 10:50 AM	Rate (0)
plcordoba 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....
plcordoba Posts: 21 Rating: (1)
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 Posts: 341 Rating: (24)	Hi plcordoba, Instead of writing : count = HMIruntime("var1") please write: Set count = HMIRuntime.Tags("var1") rit03
rit03 Posts: 341 Rating: (24)
Suggestion To thank Quote Answer

Share this page:

Share this page on...