Hello there,

I've been using the OPC UA Client Library described here to get values from some S7-1500 CPU and it was working well until now on Windows 7/Office 2013 32 bits.

However I've been trying to use it on Windows10/Office 2016 32 bits now and the example provided in the link does not seem to work anymore.

Im guessing the version of VBA as evolved with the last version of Office.

The error code i faced during execution was "automation error". It shows up whenever you want to create an object.

"Private Sub CommandButtonGetEndpoints_Click()

This line, for example is not working anymore.

What i have already tried without success is the following :

- "Sheets(3).m_OpcUaClient = New OpcUaClient" (remove set)

- " Set Sheets(3).m_OpcUaClient = CreateObject ("OpcUaClient") (wont recognized)

- " Set Sheets(3).m_OpcUaClient = CreateObject ("OpcUaClientLibrary.OpcUaClient") (same without set)

Any VBA expert around here to give me some hints ? Thanks

Hello,

Updating .NET framework to the latest version via windows update and launching Excel as administrator seems to have fixed my issue if that can help anyone.