Macro - Export to excel

Thu, 30 Oct 2014 04:49:00 GMT

Hi friends,

I am encountering below issue when trying to export the report to excel -

1. How can we export all the objects of the sheet in same UI format into excel?? As the report has multiple table objects which are expandable so can't specify the cell numbers in excel as it could dynamically exporting the objects.

2. Also, the below macro works fine with onea table object - CH25 but not when I use the ID of a container object (CT01). Can any one help how can I export all the objects of a container by looping or by any other means?

Sub Test1

set obj = ActiveDocument.GetSheetObject("CH25")

obj.ExportBiff "C:\test.xls"

End Sub

Thanks,

Deepti Gupta

topic Macro - Export to excel in QlikView

Macro - Export to excel