Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ?
Hi Jonathan,
Sorry i want to extract straight table and it has 20 expressions.
Regards,
sushil
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
Hi Ashfaq,
I want excel not qvd.
Regards,
sushil
try this
sub ExportExcel
set obj = ActiveDocument.GetSheetObject("CH02")
obj.ExportBiff "C:\test.xls"
end sub
Regards
ASHFAQ