topic Export objects to multiple sheets in excel in QlikView

Export objects to multiple sheets in excel

Mon, 30 Apr 2012 11:55:57 GMT

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.

Export objects to multiple sheets in excel

stevedark — Mon, 30 Apr 2012 12:04:25 GMT

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