Kkula
Browse Questions » Communication / Networks: Open connectivity protocol Information Towards Excel sheet through Vb Reusable code block

About User

Questions Asked: 30.3K

Answers Given: 0

0
  • Open
  • New

Communication / Networks: Open connectivity protocol Information Towards Excel sheet through Vb Reusable code block

Dear Experts,
I have data from PCS7 AS to be transferred to an OfficePC Which has only OPC Scout but no WinCC/Data Bridge etc.,
A PC station is configured in that Office PC Using the NCM PC manager and an OPC connection configured with AS using netpro.
The OPC scout Shows all the data from the AS in the OPC.Simatic Net Server.
Now, i have to export the data from OPC Scout to an Excel file.
So i downloaded an example code From Siemens net through the ID.
http://support.automation.siemens.com/WW/view/en/24299099
Fortunately, It Shows the values in the format and im able to read/ Write values.
name of item
ItemID
Value
Read
Write
MB0
S7:[DEMO]MB0
66
66
MB1
S7:[DEMO]MB1
44
44
MB2
S7:[DEMO]MB2
55
55
MB3
S7:[DEMO]MB3
77
77
I need to View some more values in the excel sheet like MD5, MB5, etc.
How can i do it?? Its Very Very Urgent.
Any body expert in VB can help or is there any other easy method??
Thankyou,
VishnuKarthick.

0 Likes 0 Favourites 0 Followers 0 Comments
Answers(0)