export excel automatically

[#1]

Hi all,

I have a new requirement.I need qlikview table data export to excel automatically by daily basis.

can you please give some guidance.

By using micro we can export by clicking only but my client need daily basis without open the report.

Thanks

Surender

[hariprasadqv]

Hi Surender,

1.Create a qvw with a macro that can export data to excel.

2.Add Trigger to it in Document properties to activate sheet

3.Add Trigger to in sheet properties for calling Macro on sheet activation.

4.Create Batch file to run QVW

5.Schdule Batch file in windows schduler.

Thanks

[Siva_Sankar · Accepted solution]

Reload the attached file.

[pnn44794]

Hello Sivasankar:

I have a couple of questions if you don't mind.  Does the 4 at the end of the obj1.Export line represent the number of columns to be exported?  And my second question is there a way to export the data in .xlsx format?  Thanks in advance.