Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-10-30 12:49 AM

Macro - Export to excel

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

556 Views
0 Likes
0 Replies