export chats to excel using Macros

[Anonymous]

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.

[ashfaq_haseeb]

Hi,

Have a look at the attached Application.

Regards

ASHFAQ

[jagan]

Hi Satish,

Check this link for variety of macros

Useful Qlikview Macros

Hope this helps you.

REgards,

Jagan.

[#4]

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

[#5]

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