ActiveX component can't create object

[Former Member]

Hi Guru,

I tried to connect SAP B1 from Excel macro, but I got error 'ActiveX component can't create object' wherever I tried to call any B1 object.

The workstation is 64bit windows 2008 server which running B1 server and B1 client.

The same macro works well on other workstations, no matter 32bit or 64bit OS, it looks like it only gets problem on this particular machine.

Very apprecate if you could provide any idea about this.

Thanks

Tim

[Former Member]

Hi Tim........

Have you installed Activex Component?

Please install first and then try......

Regards,

Rahul

[Former Member]

Hi Rahul

Could you show me more details about installation of ActiveX Component? We are using Windows server 2008 R2 standard OS now.

Thanks

Tim

[Former Member]

Hi Tim......

You can download Activex Component from any of the sites by googling.

http://download.cnet.com/windows/activex/

Also please check this link also for how to install that.......

http://superuser.com/questions/133628/how-can-i-install-activex-in-windows-2008-r2

Hope this will help you......

Regards,

Rahul

[Former Member]

Hi Tim,

Have you installed the 32bit or 64bit version of Microsoft Office on that machine? If it's the 64bit version then I'd recommend you uninstall it and use the 32bit version instead (no real difference unless you need to load very, very large spreadsheets).

Kind Regards,

Owen

[Former Member]

Hi Owen

Thanks for your quick update!

Yes, we have office installed on the server, and we only process small excel files which only have few lines.

I tried to reinstall DI PAI, but no luck.

Thanks

Tim