当前位置: 动力学知识库 > 问答 > 编程问答 >

vba - Microsoft Visual Basic for Applications, clearSCADA, SCADA

问题描述:

Developing an interface in excel to access a database in a SCADA application (clearSCADA by Schneider)

Require the ability to list all properties of an object in Visual Basic behind excel.

It is very simple to list all the object based on a property like "InService". And to create an array of all objects.

Set oPnts = myFolder.List("CDBObject")

For Each item In oPnts

Set oObj = oServ.FindObject(oPnts.item(Count + 1).FullName)

Next Item

But I am not able to list all the properties of an object. Like CNDP3AnalogIn.

I want to do something like this. oObj.list and get an array of all the properties associated with object.

How I am solving this problem currently is hard coding all the properties associated with an object and using 'case select' statements and printing them to excel. This method is not dynamic and does not solve the issue of new properties added with .xml files.

I think the issue might have to do with the ability to use methods such as 'list' on an object to find properties.

Willing to write some C to approach this issue from another perspective. Just a push in the right direction would be great!!

Build details:

Excel 2016

Microsoft Visual Basic For Application 7.1

VBA: Retail 7.1.1056

分享给朋友:
您可能感兴趣的文章:
随机阅读: