Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

export chats to excel using Macros

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.

4 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Have a look at the attached Application.

Regards

ASHFAQ

jagan
Luminary Alumni
Luminary Alumni

Hi Satish,

Check this link for variety of macros

Useful Qlikview Macros


Hope this helps you.


REgards,

Jagan.

Not applicable
Author

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

Not applicable
Author

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