topic export chats to excel using Macros in QlikView

export chats to excel using Macros

Anonymous — Wed, 20 Aug 2014 06:04:02 GMT

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 — Wed, 20 Aug 2014 06:08:18 GMT

Hi,

Have a look at the attached Application.

Regards

ASHFAQ

jagan — Wed, 20 Aug 2014 06:21:36 GMT

Hi Satish,

Check this link for variety of macros

Hope this helps you.

REgards,

Jagan.

Wed, 20 Aug 2014 06:35:23 GMT

Hi,

Refer to this Link

Step by Step implementaion is there with very good explanation

Thanks and Regards,

Vivek

Wed, 20 Aug 2014 06:37:57 GMT

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