Online Forums

Technical support is provided through Support Forums below. Anybody can view them; you need to Register/Login to our site (see links in upper right corner) in order to Post questions. You do not have to be a licensed user of our product.

Please read Rules for forum posts before reporting your issue or asking a question. OPC Labs team is actively monitoring the forums, and replies as soon as possible. Various technical information can also be found in our Knowledge Base. For your convenience, we have also assembled a Frequently Asked Questions page.

Do not use the Contact page for technical issues.

Is it possible to browse OPC items in Excel?

Start
Prev
1
Next
End

1

support
Offline
Moderator

More

25 Oct 2022 16:59 #11168 by support

Replied by support on topic Is it possible to browse OPC items in Excel?

Hello,

I think there are three parts to this answer:

1) Excel Option, as such, has no feature for OPC browsing (from inside Excel). Excel Option is strictly for data subscriptions, reads, and with some limitations, writes.

2) It is possible to write code in VBA in Excel, and use QuickOPC COM interface to perform all OPC operations, including browsing. This, by itself, does not show any user interface for the browsing, if that's what you are after.

3) It *should* be also possible to also invoke QuickOPC browsing dialogs from VBA code in Excel, as from any VBA/VB6 code. We have not tested this.

Best regards

Please Log in or Create an account to join the conversation.