Macro to export table to exact cell in excel

[#1]

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

1. Run Macro
2. Macro opens excel file as per above file path
3. Macro exports table "CH013"
4. Macro pastes table "CH013" to cell B2 on sheet 1 in the file path above, overwriting whatever is already there.
5. Macro saves excel file and closes it.

Any help would be much appreciated

Thanks

Andrew

[#2]

This is much easier with Nprinting! haha

[#3]

Helpful but I don't have it

[marcus_sommer]

Have a look on postings like these: http://community.qlik.com/search.jspa?q=macro+export+sheet&type=document

- Marcus

[Miguel_Angel_Baeyens]

Hi Andrew,

See the macro code used here: Export to Excel

Especially curSheet.Range

Miguel