exporting objects from sheet to excel with the button by using macro

Fri, 04 May 2012 11:55:10 GMT

i have created a report and now i want to create a button 'export to excel' and this button must export the objects of the active sheet to the excel...how cani achieve that ???

explain it with a simple example???

exporting objects from sheet to excel with the button by using macro

Fri, 04 May 2012 16:42:44 GMT

Define your macro as:

sub exportAll

set s = ActiveDocument.ActiveSheet

for i=0 to s.NoOfSheetObjects - 1

s.SheetObjects(i).SendToExcel

end sub

Then make a button an make it run external->macro name exportAll

This will export everything on the active sheet to excel.

Hope this helps,

Brandon

topic exporting objects from sheet to excel with the button by using macro in QlikView

exporting objects from sheet to excel with the button by using macro

exporting objects from sheet to excel with the button by using macro