Hi All
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
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.
- Macro saves excel file and closes it.
Any help would be much appreciated
Thanks
Andrew