Professional OPC
Development Tools

logos

lupa

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.

  1. Forum
  3. Discussions
  5. QuickOPC-UA in COM
  7. Reading, Writing, Subscriptions
  9. VBA: How to get a Word from opc-ua server?

VBA: How to get a Word from opc-ua server?

More
07 Aug 2015 13:11 #3481 by support
Replied by support on topic VBA: How to get a Word from opc-ua server?
Unfortunately this is a question that should be directed to the OPC server vendor.

On our side, as long as you provide a valid NodeId and the server returns a value, we will give you the value (sometimes with conversions necessary to adjust to the COM world).

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

More
07 Aug 2015 12:03 #3480 by LaurentzT
VBA: How to get a Word from opc-ua server? was created by LaurentzT
Hello,


I'm testing your COM object in MS Access and this code works fine:

Dim strTest As String
strTest = client.ReadValue("opc.tcp://STP-OPC-01.domain1.local:55101?None?opcfoundation.org/UA/SecurityPolicy#None", "ns=3;s=s7400.db500.88,x0") 'bool

strTest = client.ReadValue("opc.tcp://STP-OPC-01.domain1.local:55101?None?opcfoundation.org/UA/SecurityPolicy#None", "ns=3;s=s7400.db500.89,b") 'Byte

strTest = client.ReadValue("opc.tcp://STP-OPC-01.domain1.local:55101?None?opcfoundation.org/UA/SecurityPolicy#None", "ns=3;s=s7400.db500.90,w") 'Int

but I don't know the syntax to get a Dint, Word, DWord, Real, Date, Time, Char and String.

Any idea?

db500 is the database
88 is the address
x0 is the datatype

Thanks!

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

Moderators: support
  1. Forum
  3. Discussions
  5. QuickOPC-UA in COM
  7. Reading, Writing, Subscriptions
  9. VBA: How to get a Word from opc-ua server?
Time to create page: 0.062 seconds