Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Calling Excel Macro in Qlikview Macro

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 !

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Calling Excel Macro in Qlikview Macro

Did you create an excel application object? Something like

SET xlApp = CREATEOBJECT("Excel.Application")

xlApp.Run ...myexcelmacro...


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Re: Calling Excel Macro in Qlikview Macro

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 ?