I have a macro in Excel that connects to SAP.
With Office 32 bits and Windows 7 64bits works perfectly.
With Office 2010 64bits it returns the error '429' An ActiveX component cannot create the object.
I've tried to register libsvr32.dll and copy it to system32 directory but nothing works.
The error appears at line
Set R3 = CreateObject("SAP.Functions")
I think there's some incompatibility between office 64 bits and SAP but I'm no really sure.
Could I use another method to connect SAP instead of libsvrc32.dll?
Help will be appreciated!