Hi everyone out there, im new in qlikview, I was doing export stuff and everything works fine when i only export 3 sheets into 1 book, the problem came when i was trying to export 4 sheets or more, i suppossed the reason was that a excel books has 3 sheets default when you open a normal excel file, so my question is how to export 4 or more sheets into a book, by the way i am only exporting data from straight tables, here is the code of the macro im using :
Depending on this setting to stay the same across multiple user workstations is risky. (I normally change that setting to 1. It saves having to verify the extra Sheet(2) & Sheet(3) are blank when exchanging Workbooks. Besides, occasionally adding sheets is faster than constantly deleting two.)
It would be safer to get a Sheet count after the
set XLDoc = XLApp.Workbooks.Add
then add sheets as necessary.
Alternately, you could change the "Include this many sheets" option to the needed sheet count in your script before adding the Workbook.