Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone!
I've made a macro to export to Excel some pivot tables from QlikView. It works well, but due to the heavy formatting required by the client, it takes quite a while to execute. How can I open a template Excel file that already has all the formatting required by the client, paste my tables in the template and then save the Excel file as a separate file, in VBScript? At your request, I can provide some excel templates.
Even if we paste the data into the excel, we have to do some formatting i.e cell merge, rows are not fixed so we should make sure that the should not overwritten by data etc. I'll try my level best and get back to you.