How to export QV table to excel automatically

[#1]

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]

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

[#3]

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!!