Macro help exporting to excel

Thu, 05 Mar 2015 14:40:25 GMT

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

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.
Macro saves excel file and closes it.

Any help would be much appreciated

Thanks

Andrew

topic Macro help exporting to excel in QlikView

Macro help exporting to excel