I have a straight table in Qlikview which i need to export to a specific cell in an excel document.
The excel document is located in the following path S:\Indemnity Performance\Functional - Claims Insight\Exception Reporting\Qlikview\UK\Qlikview Monthly Data Check\Monthly Reconciliation UK Jan 15.xlsx (Please note this file will not be open when the macro is run)
I want the macro to export the below table to the above file and paste into into sheet 1 cell b2
Header 1
Header 2
Header 3
Header 4
Header 5
Header 6
150
2
3
4
5
6
I am assuming that it would need to be some sort of a macro.
So basically if someone could write the macro which would follow the below process
Run Macro
Macro opens excel file as per above file path
Macro exports table "CH013"
Macro pastes table "CH013" to cell B2 on sheet 1 in the file path above, overwriting whatever is already there.
