PostReload trigger exporting chart to xls does not work

[jimmygohhanjie]

Hi ,

Thanks for your attention.

I have setup the below marco to run on Post reload. however it does not work. (screenshot of security at the bottom).

The marco works fine when i  click TEST on the Edit Module dialog.

However it does not work when i reload my data.

This is running on my local machine, not server.

Thanks for your time, and appreciate your assistance on this.

User setting security

Document Security.

[olivierrobin]

hello

what do you mean by doesn't work

error messages ? if so which ones ?

[jimmygohhanjie]

Hi,

Apologies for the delayed reply, was away from work.

There is no error msg and the expected excel was not generated. from my Qvw.

Auto Export to Excel File (upon reload) using qv macro

I have tried the above solution. The Solution QVW does generated the excel.

I have model it the same. however my QVW does NOT generate the excel.

i am guessing it is the DOCUMENTING setting. wondering which checkbox need to be tick or untick.

I cant share my QVW as it contain sensitive data.

[tamilarasu]

Hi Jimmy,

Why do you have such a long space in your file path?

Jimmy Goh wrote:

The marco works fine when i  click TEST on the Edit Module dialog.

However it does not work when i reload my data.

Are you sure? Did you see the file get exported to the specified folder?

[jimmygohhanjie]

Thanks for spotting..

i will need to recreate and try again.

As advised by my IT, our server does not have excel. this function will be removed.

However, i will still try to make sure my local will work.

Thanks for your time and sharp eye.