topic Macro Script in QlikView

Macro Script

ajaykumar1 — Sat, 11 Oct 2014 09:36:13 GMT

Hi Everyone,

I need some help on macros to provide these facilities.Currently my applications are running based on scheduling in the server.(QV11).

1.To send the individual tables data to the users in excel format.

2.Based on the macro 3 or 4 tables data to go excel format like sheet1,sheet2,sheet3.

Please suggest me the same if in case any batch file creation required and how that file will work.

Sharing of sample app is very helpfull.

Thanks in advance,

Ajay

vikasmahajan — Sat, 11 Oct 2014 09:52:05 GMT

PFA sample in sample we have code for export to excel , may help you

Vikas

ajaykumar1 — Sat, 11 Oct 2014 10:08:10 GMT

Thanks Vikas your app is helped but am getting some errors.

Could you please help the same by applying the macro with the attached app.

1.I need to mail the tables data in excel format two sheets wise by product,country wise.

2.In second way i have to send the data as sheet1,sheet2.

More thanks,

Ajay