Extracting the table chart to excel

[#1]

Hi Frnds,

        I want to export the table chart to excel which is size of 300 mb. I am doing this by button using macro. But our platform team have policy like u can't extract the file which is more than 32 mb so not geting approval from our platform team. But they are okay while reloading itself if we extract and save that file in shared path  so tried with post reload option but in the qmc it will not work. So need your suggestion to resolve this issue.

[JonnyPoole]

Its not the same thing but you can dump any table in the data model (not a UI chart) to TXT format (not excel) using the STORE command

store mytable into myfile.txt (txt);

Then the TXT is re(generated) every time the QVW executes.

Could that work or do you need those table chart functions ?

[#3]

Hi Jonathan,

     Sorry i want to extract straight table and it has 20 expressions.

Regards,

sushil

[ashfaq_haseeb]

Hi,

I think this macro will do the job. It will store your table to qvd.

sub MyMacro
set obj = ActiveDocument.GetSheetObject("CH02")
obj.ExportEx "C:\test.qvd", 4 
end sub     

Store in the path you like.

Let me know if that worked.

Regards

ASHFAQ

[#5]

Hi Ashfaq,

  I want excel not qvd.

Regards,

sushil

[ashfaq_haseeb]

try this

sub ExportExcel

set obj = ActiveDocument.GetSheetObject("CH02")

obj.ExportBiff "C:\test.xls"

end sub

Regards

ASHFAQ