Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I urgently need a help over a script I'm writing, I'm also new to macro and qlikview. I intend to migrate about 60 straight tables (objects) from qlikview into just one excel sheet. I've manually imported the objects into the excel sheet, created a range in excel for each of the objects, with the intention that each object will be in the already created range each time the macro is run in a predetermined sequence. I've also change the object id of each of the objects to match the range in excel. I intend to have the an excel sheet opened and cleared each time the script is run, but want to maintain the previously created ranges, and migrate the tables into those ranges dynamically in the right sequence. Please see below the part of the script that need updating. Thanks
.
.
.
Objects = SourceQVW.Sheets("QVSheet").GetSheetObjects
For i = lBound(Objects) To uBound(Objects)
object(i).CopyTableToClipboard TRUE
ExcelSheet.vTable.pastespecial
next
End
Thanks for your response, It's all sorted now. It's such a very complicated MACRO to write anyway, but I'm glad it's all sorted now. Thanks
Not sure if you have the QlikView API QVW or not, here is a link to that from the Help site:
It is just a QVW file with all the available QlikView APIs you can use. Afraid I am not much help on the Excel APIs, Microsoft may be the better place to get help on that side of things. I know there have been a fair number of Excel export macro posts lately, so if you have not searched, I would recommend doing that too as you may find what you need that way too. Sorry I do not have anything better.
Regards,
Brett
Thanks for your response, It's all sorted now. It's such a very complicated MACRO to write anyway, but I'm glad it's all sorted now. Thanks