Export large table to Excel

[#1]

All,

Is there a way to export large table boxes ? it is running out of memory, when exporting to Excel or in copying to clipboard.

Regards

[bumin]

Hi,

you can write a macro to export it as CSV. I have exported even big data with this method

regards

Bumin

[bumin]

here the macro:

sub vCSV

'Download Sheet ojbect data to CSV

set sObject = ActiveDocument.GetSheetObject("CH321")

sObject.Export "GDPdU0.csv", ";"

End Sub

[#4]

thanks a lot

should i type the macro in the Edit Script editor below the other commands ?

what if i cannot access the edit script functionality in the QLikView document I wish to export from (limited r/w access) ?

thanks

[bumin]

you have to create a button-object

find attached an example qvw