Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using Export to Excel_variant(2) macro in my qlikview document.
In this I want to save 2 reports(Straight Tables) in a single excel file as two different sheets.
This macro is working well on my local pc but not working on Access point and browser.
How can I achieve this? Please help me out.
Thanks,
Hi Shail,
which client are you using? As macros will only working in the IE Pluign.
Andy
Have you enabled "Print and Export to Excel" option in QMC?
Some macros can be unusable in AJAX
Have you tried to prepare reports including these tables and then print them ( or save ) via Access Point?
You can add a table with values from both tables and make a report including that table ( as in a attached qvw file )
which client ur using? ajax won't support most of the macro's.
Hi Andy,
Thanks,
Its also not working on IE .
is there any script problem, means path etc.
Hi Thomas,
Thanks for reply,
Send to excel is working on browser, but Macro for export to excel only working on local computer not working on browser.
Thanks
Do you have another idea except merge two reports.
I am still stuck with my problem, not find any solution till now.
Thanks,
Shaila
Hi Shaila,
to this issue read this, is very helpful :
http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/
kindly
Beck