topic How to export QV table to excel automatically in QlikView

How to export QV table to excel automatically

Thu, 21 May 2009 14:44:32 GMT

Im trying This method but it 's not working .

OnPostReload (settings-->document properties, macro tab) .

sub Exportit() set Chart = ActiveDocument.GetSheetObject( "CH01" ) chart.exportex "c:\test.xls",5 end sub "

Im getting Error " chart.exportex "c:\test.xls",5 ---- > "Object doesn't support this property or method: 'Chart.exportex' "

Thanks for your help,

sparur — Thu, 21 May 2009 16:54:51 GMT

Hi, Önder

I'm created test example with your macros. and assosiate this macro with button. And after click my button I get MS Excel file in C:\.

my QV version 8.5.

see in attachment

Fri, 14 Aug 2009 03:46:12 GMT

Hi ,

I am looking for macros to export charts to excel and found your reply.

But the qvw you attached is empty, do you mind upload it again?

Thanks!!