I have some old ActiveX controls and DLLs written in VB6 that interact with some Excel VBA code. We have always recommended that people use the 32-bit version of Excel, but I thought I'd have another go at getting this to work in 64-bit.
Is this possible?
The objects are created in the VBA code using CreateObject (late binding), but this fails when using the compiled ocx/dll. If I run the code in the VB6 IDE though, it can create the object with no problem.
Any suggestions appreciated.