Dynamic name for Excel Report

[balanandam]

Hi All,

I wanted to implement this in my project. My report as below

when I download this in excel, it should on the name of the header showing here. Can any one give idea ?

Br, Balanandam

[prma7799]

Please check this

https://community.qlikview.com/thread/178080

[balanandam]

P M, thanks for the quick response.

I see there is a Macro code written in the article you shared Me. I wanted to know on how this code to be triggered ? Will it work when I Click on Excel Export or do I need to create a button to trigger the action which runs this Macro?

Br, Balanandam

[tresesco]

You need to create a button

[prma7799]

As tresesco‌ said

You need to create a button.

[shiveshsingh]

Hi

You can use a button for getting the desired result

[balanandam]

I've added this code Macro area, triggered by Button action. its not running and just opens this code when I click on Button. One question: Do wee need Excel installed in Server ? if yes, we don't have option then I need to go for PDF for the same concept.

Br, Balanandam

[balanandam]

Forgot paste the error:

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

it's same as above said. How to avoid this ?

Br, Balanandam

[balanandam]

I've changed security as below:

Neither throws error nor working as expected i.e, Report not getting generated. what else I'm missing here any idea ?

Br, Balanandam

[balanandam]

Hi all,

this is work when using desktop application but not thru Access Point (Browser), any sitting needed to achieve this ?

Pls. advice.

Br, Balanandam