Need an OPC DA automation wrapper that works with a 64bit version of Excel (2013 & 2016)|Classic OPC: DA, A&E, HDA, XML-DA, etc.|Forum|OPC Foundation

Avatar
Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
Lost password?
sp_Feed sp_PrintTopic sp_TopicIcon
Need an OPC DA automation wrapper that works with a 64bit version of Excel (2013 & 2016)
Avatar
Gary Muir
Plymouth
New Member
Members
Forum Posts: 2
Member Since:
10/31/2019
sp_UserOfflineSmall Offline
1
10/31/2019 - 08:08
sp_Permalink sp_Print

I have the Graybox OPC Automation Wrapper (gbda_aut.dll) which I am using to connect Excel 2013 (via VBA) to an OPC server (Rockwell FactoryTalk Gateway).

All is good until I try and add and item to the group I have created. 

When I run the VBA code Excel crashes with a just-in-time error.

Here is my code:

Dim OPCItemID1 As String
Dim ClientHandle1 As Long

OPCItemID1 = “[OPCLabel]BarcodeScanned” ‘Scanned Barcode Value
ClientHandle1 = 1975

myOPCGroup.IsSubscribed = False ‘Unsubscribe group before adding items

Set myOPCItem = myOPCGroup.OPCItems

myOPCItem.AddItem OPCItemID1, ClientHandle1

—————

Does anyone have any ideas of what is wrong or know of a OPC DA automation wrapper that will work with Excel 2013?

 

Thank you 

Avatar
Christopher Panici
New Member
Members
Forum Posts: 2
Member Since:
10/24/2019
sp_UserOfflineSmall Offline
2
01/31/2020 - 09:58
sp_Permalink sp_Print

I have the same issue – I am using OPCDAAuto.dll and it is not working with 64-bit excel.

PLEASE IF ANYONE HAS A NEW REDIST TO USE LET US KNOW.

Chris

Avatar
Meir Tseitlin
New Member
Members
Forum Posts: 1
Member Since:
12/12/2016
sp_UserOfflineSmall Offline
3
07/20/2020 - 07:56
sp_Permalink sp_Print

I investigated this problem deeply and even though the sample OPC Foundation DA code wrapper provided in the examples can be compiled to 64 bit, there are many modifications that needed to made (I.e. 64 pointers are casted into 32bit variables – and this is why crash occurs). I assume that Graybox DLL was compiled without those modifications also (I experienced the same crash in my own DLL and in theirs).

Forum Timezone: America/Phoenix
Most Users Ever Online: 510
Currently Online:
Guest(s) 30
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Forum Stats:
Groups: 2
Forums: 10
Topics: 1444
Posts: 4887