scripts

hello people, i need help with scripts

i need example of scripts wich will do get information from A1 window of EXEL file, when i unvert bit tag in wincc, 

who can write examle or give me litrerure for it

Perhaps this link is helpful ( I never used it myself):

https://support.industry.siemens.com/cs/ww/en/view/69846238

Hello kormotech

first of all the good old question do you use WinCC Advanced/Comfort or WinCC Professional Runtime?

In the WInCC V7.X Help is a smal example for you use case. I Think it should work also in VB Script in TIA Portal:

-------------------

'VBS113

Dim objExcelApp

Set objExcelApp = CreateObject("Excel.Application")

objExcelApp.Visible = True

'

'ExcelExample.xls is to create before executing this procedure.

'Replace <path> with the real path of the file ExcelExample.xls.

objExcelApp.Workbooks.Open "<path>\ExcelExample.xls"

objExcelApp.Cells(4, 3).Value = 12345

objExcelApp.ActiveWorkbook.Save

objExcelApp.Workbooks.Close

objExcelApp.Quit

Set objExcelApp = Nothing

--------------------

hope it helps

Bye Murof

 Hi Mr IBN-Service,

IBN-Service

Perhaps this link is helpful ( I never used it myself):

https://support.industry.siemens.com/cs/ww/en/view/69846238

 If not your professional secret what yours solution for this the problem (small idea or same guidelines)?

 best regards

 zzvss

zzvss

 Hi Mr IBN-Service,

IBN-Service

Perhaps this link is helpful ( I never used it myself):

https://support.industry.siemens.com/cs/ww/en/view/69846238

 If not your professional secret what yours solution for this the problem (small idea or same guidelines)?

 best regards

 zzvss

As already said,
I would test the link that I have given.

Usually, I send values and status signals using a CSV file if I need them in other applications.

But there are so many solutions (i.e. OPC, ProDave...) that you will find for this problem, it is really not a "secret".

Murof

...

In the WInCC V7.X Help is a smal example for you use case. I Think it should work also in VB Script in TIA Portal:

...

I'm afraid, this example is not useful for TIA advanced.

WinCC V7.x <> TIA

Perhaps you can do a test?

Hi Mr. IBN_Service,

Thanks for Your answer.

[OFFTOPIC]

From the portal somebody is write: "Gut Ding will Weile haben".

Thanks H.J.

Best regards.

zzvss

IBN-Service

 

Murof

...

In the WInCC V7.X Help is a smal example for you use case. I Think it should work also in VB Script in TIA Portal:

...

 

I'm afraid, this example is not useful for TIA advanced.

WinCC V7.x <> TIA

Perhaps you can do a test?

 Hello IBN-Service

First of all i have tested the Script in a WinCC Advanced Runtime V13 SP1 with an Excel 2010.

-> it works without Problems also in this TIA environment.

you are right that WinCC V7.xSCADA ist totally different to TIA Portal but The VB Script functionality is (excapt the Object Model of the Runtime) basically the same in both worlds.

So the MS Automation Interface which the Example uses you can use in any VB Script at a computer on which MS Excel is installed.

So you havent to be afraid

Bye Murof

New question published by Vikram Shinde 77 is split to a separate thread with the subject Problem regarding the VBS in Wincc TIA V13.

Best regards
The Helping Hand

thank you, i have learn how write script of value to exel file.

can you show me how write scripte to open picture from desctop on computer to visiolisation to tia portal

and how get text from exel to tia, i try to write script but i dont know how call text field  from tia portal in VB script