topic Re: Calling Excel Macro in Qlikview Macro in QlikView https://community.qlik.com/t5/QlikView/Calling-Excel-Macro-in-Qlikview-Macro/m-p/614850#M1112406 <HTML><HEAD></HEAD><BODY><P>Thanks. Qlikview recognizes this.</P><P>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 ?</P></BODY></HTML> Wed, 12 Mar 2014 17:44:35 GMT 2014-03-12T17:44:35Z Calling Excel Macro in Qlikview Macro https://community.qlik.com/t5/QlikView/Calling-Excel-Macro-in-Qlikview-Macro/m-p/614848#M1112403 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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?</P><P>Tried by analogy with Excel, but wasn't recognized :&nbsp;&nbsp; Application.Run "MacroFile.xlsm!Module1.Macro1"</P><P></P><P>Many thanks !</P></BODY></HTML> Fri, 07 Mar 2014 14:57:54 GMT https://community.qlik.com/t5/QlikView/Calling-Excel-Macro-in-Qlikview-Macro/m-p/614848#M1112403 2014-03-07T14:57:54Z Re: Calling Excel Macro in Qlikview Macro https://community.qlik.com/t5/QlikView/Calling-Excel-Macro-in-Qlikview-Macro/m-p/614849#M1112404 <HTML><HEAD></HEAD><BODY><P>Did you create an excel application object? Something like</P><P>SET xlApp = CREATEOBJECT("Excel.Application")</P><P>xlApp.Run ...myexcelmacro...</P></BODY></HTML> Fri, 07 Mar 2014 15:00:35 GMT https://community.qlik.com/t5/QlikView/Calling-Excel-Macro-in-Qlikview-Macro/m-p/614849#M1112404 Gysbert_Wassenaar 2014-03-07T15:00:35Z Re: Calling Excel Macro in Qlikview Macro https://community.qlik.com/t5/QlikView/Calling-Excel-Macro-in-Qlikview-Macro/m-p/614850#M1112406 <HTML><HEAD></HEAD><BODY><P>Thanks. Qlikview recognizes this.</P><P>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 ?</P></BODY></HTML> Wed, 12 Mar 2014 17:44:35 GMT https://community.qlik.com/t5/QlikView/Calling-Excel-Macro-in-Qlikview-Macro/m-p/614850#M1112406 2014-03-12T17:44:35Z