Export several QV tables into different excel sheets of the same workbook

[#1]

Dear All;

I need to create a button to export several QV tables into different excel sheets of the same workbook. One excel sheet to each QV table. Could anyone help me on this?

[#2]

Hi

You need to write a macro that uses ole automation to create an instace of excel and then export the tables one by one.
Google for excel createObject and you'll get lots of examples of how to automate Excel. Refer to the QV Api guide to get examples for getting table data.
A quick search on this forum might also help 😉 This thread should be interesting.
http://community.qlik.com/forums/p/20444/78699.aspx#78699

If this doesn't help, I think I have an example of this somewhere, I'll see if I can find it.

/Fredrik