Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

chintannarendra
New Contributor III

Excel Macro Error- ActiveX component can't create object: 'Excel.Application'

Dear Friends

I am trying to run a macro for excel email, however I am getting error as below:

ActiveX component can't create object: 'Excel.Application'

I do not have MS Office/Excel installed on the Qlikview server. Is it possible to achieve above task without installing MS Office

on the Qlikview Server?

Kindly help.

Thanks & Regards

Chintan Gala

4 Replies
stabben23
Honored Contributor

Re: Excel Macro Error- ActiveX component can't create object: 'Excel.Application'

i'm afraid not

chintannarendra
New Contributor III

Re: Excel Macro Error- ActiveX component can't create object: 'Excel.Application'

Dear Staffan

Thanks for your replly. Is there any workaround available to get Excel email from QlikView Dashboard without

installing MS Office/Excel on the Server.

Regards

Chintan Gala

stabben23
Honored Contributor

Re: Excel Macro Error- ActiveX component can't create object: 'Excel.Application'

Have a look here

chintannarendra
New Contributor III

Re: Excel Macro Error- ActiveX component can't create object: 'Excel.Application'

Thanks Staffan. You are correct with your response. It is NOT possible to by pass installation of Microsift.

Regards

Chintan Gala