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