Skip to Content
5
Feb 19, 2014 at 10:19 AM

Connect excel 2010 64 bits with SAP

5135 Views

Hi!

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!

Thanks!