topic Macro to run an Excel Macro in QlikView

Macro to run an Excel Macro

Thu, 13 Jan 2011 22:53:59 GMT

Hi All,

I have an Excel Worksheet template that I dump data into from Qlikview. I have a macro in Qlikview that dumps all the different tables into this Excel template but to do some finishing touches on the template I have a Macro in the worksheet that I need to run. How do I call this macro from within my qlikview macro?

Thanks,

Austin

Macro to run an Excel Macro

Anonymous — Fri, 14 Jan 2011 06:00:35 GMT

There are plenty of examples online if you google for example: "Vbscript run macro in Excel"

Here's an example I think should work. Not tested:

Set objExcel = CreateObject("Excel.Application")

objExcel.Visible = True

Set objWorkbook = objExcel.Workbooks.Open("C:\Documents and Settings\My Documents\Test.xls")

objWorkbook.Application.run "Test.xls!Macro.Macro"

Macro to run an Excel Macro

Fri, 14 Jan 2011 16:25:07 GMT

Thanks Johannes,

It worked like a charm.