Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How can i export multiple charts to my excel sheets using macros. kindly send me example that would be more useful for us .
Thanks in advance.
Hi,
Have a look at the attached Application.
Regards
ASHFAQ
Hi Satish,
Check this link for variety of macros
Hope this helps you.
REgards,
Jagan.
Hi,
Refer to this Link
QlikTip #32: Exporting multiple QV objects to a single Excel document
Step by Step implementaion is there with very good explanation
Thanks and Regards,
Vivek
create a chart which you want to export as excel
then go to macro editor or press ctrl+m
and paste following code
sub Createexcel
set obj = ActiveDocument.GetSheetObject("CH01")
obj.ExportEx "C:\Product.xls", 3
end sub
and now create a button and add action to the button by add action->external->run macro and type macro name which
is Createexcel. now finish.
so whenever you click on button an excel file will be created to the c:\ drive with name Product.please make sure
you have mentioned correct chart id as I have mentioned it as CH01 you can replace it by your chart ID.
Hope this will help you.
Regards
Bhawna