Calling Excel Macro in Qlikview Macro

[#1]

Hi,

I have a QV document with a macro to export in xlsx. The aim is to produce a handy work file for other people. I have an Excel macro in an xlsm file that makes exactly the design they want. Is there a way I could call the Excel macro in the QV macro, to get it all done together?

Tried by analogy with Excel, but wasn't recognized :   Application.Run "MacroFile.xlsm!Module1.Macro1"

Many thanks !

[Gysbert_Wassenaar]

Did you create an excel application object? Something like

SET xlApp = CREATEOBJECT("Excel.Application")

xlApp.Run ...myexcelmacro...

[#3]

Thanks. Qlikview recognizes this.

But then, either the xlsm file is open and I block myself (a pop-up in Excel indicating that the xlsm is already opened by me), either it's closed and the QV macro can't execute the Excel macro. Any ideas ?