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
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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
‎2012-04-30 07:55 AM

Export objects to multiple sheets in excel

Hi,

I have an urgent requirement.

I want to export my objects to multiple sheets in an excel.

I am hoping it can be acheived by macros via button object.

Does anyone know the macro code for the same?

Thanks in advance.

1,218 Views
0 Likes
1 Reply
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2012-04-30 08:04 AM

Hi there - you are correct in thinking that it needs to be via a macro.  You need to instantiate an instance of the MS Excel object and then insert all the data using Excel VBA calls.

I have certainly seen examples of how to do this on QlikCommunity in the past.  Try:  http://community.qlik.com/message/102052

- Steve

612 Views
0 Likes