How to generate excel dynamically from qlikview report on weekly basis

[trishita]

I want to generate an excel report from my qlikview application and store it in a specifc location in a shared drive.What could be an possible approach so that i dont have to manually download every time but it is automatically saved in the stored location or path.Should i use any job handler or trigger actions? 

[Anonymous]

I have managed to do this before using MACRO's . Create a report within the QVW and then write a VBA script in order to export and save it to the network location.  Please keep in mind this will be quite the process, but it can be done.

Generally speaking, I used to create a task in WINDOWS TASK SCHEDULER that opens a .bat file, that reloads the QVW and opens it, Then I had an ON OPEN event trigger that would start the MACRO to export and save the file.

[trishita]

so there is no job scheduler within qlikview?

[Anonymous]

No unfortunately not.  Will have to make use of a task scheduler.