Export objects to multiple sheets in excel

[#1]

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.

[stevedark]

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