How to export tables from multiple tabs to one excel sheet?
I have three tabs and each tab has one object each that needs to be exportable by the user (there are other objects in tabs like current selections, filter multi-box, clear button, text boxes, etc that I do not want the user to export)
I want the following to be exportable at once without having to export them individually
Tab 1: CH01
Tab 2: CH02
Tab 3: CH03
I want the user to be able to export all three objects to an excel at once. When these get exported to excel, I want them to appear in separate tabs on the Excel file. So, CH01 should be in Sheet1, CH02 in Sheet2 and CH03 in Sheet3 of the excel file.
Only with a macro, I think. But if you are not familiar with VBScript macros already, it might be a tad difficult. Also, I think it would have to be an unsafe macro, so the user will get warnings every time they open the QV app, and I'm not sure if it would work via the AJAX client at all.
Another option would be NPrinting by Vizubi. We use it here. It's a tad intimidating at first but you can quickly get a handle on it. If you need to do what you're suggesting in your post, you'll likely need it in the future for doing something else.
