export macro error

[#1]

Hi All,

I'm trying to use macro given in following link http://community.qlik.com/thread/80672 but edit macro page keeps popping every time I try executing it. Its happening because of following line code.

SET objExcelApp = CREATEOBJECT("Excel.Application") 

Is there any way to solve this??

Thanks

[Anonymous]

Hi,

Try this.

Give requested module security -----> system access

Current local security ----> allow system access.

PFA snapshot

Hope it may help

[#3]

Hi Nisha,

Thanks for the reply.

I tried what you suggested, still I'm having the same problem.

[jerrysvensson]

You do have Excel installed on your development machine?