topic Calling an Excel macro from QV or vice versa in QlikView https://community.qlik.com/t5/QlikView/Calling-an-Excel-macro-from-QV-or-vice-versa/m-p/189482#M52354 <HTML><HEAD></HEAD><BODY><P>I have a macro running in Excel to finalise a couple of things after my QV export. At the moment, i need to run the QV macro, then run the Excel macro manually after that</P><P>How can I call the Excel macro from within QV, or maybe even call the QV code from Excel?</P><P>Tried to do a TestFn(param1, param2) type code in Excel, and then in QV I did TestFn(Field1, field2) but QV does not like the brackets.</P><P></P><P>Thanks!</P><P></P></BODY></HTML> Tue, 15 Jun 2010 17:01:29 GMT burgersurfer 2010-06-15T17:01:29Z Calling an Excel macro from QV or vice versa https://community.qlik.com/t5/QlikView/Calling-an-Excel-macro-from-QV-or-vice-versa/m-p/189482#M52354 <HTML><HEAD></HEAD><BODY><P>I have a macro running in Excel to finalise a couple of things after my QV export. At the moment, i need to run the QV macro, then run the Excel macro manually after that</P><P>How can I call the Excel macro from within QV, or maybe even call the QV code from Excel?</P><P>Tried to do a TestFn(param1, param2) type code in Excel, and then in QV I did TestFn(Field1, field2) but QV does not like the brackets.</P><P></P><P>Thanks!</P><P></P></BODY></HTML> Tue, 15 Jun 2010 17:01:29 GMT https://community.qlik.com/t5/QlikView/Calling-an-Excel-macro-from-QV-or-vice-versa/m-p/189482#M52354 burgersurfer 2010-06-15T17:01:29Z AW:Calling an Excel macro from QV or vice versa https://community.qlik.com/t5/QlikView/Calling-an-Excel-macro-from-QV-or-vice-versa/m-p/189483#M52355 <HTML><HEAD></HEAD><BODY><P>Actually, it's not QV which doesn't like brackets, it's VBScript. You should either use</P><P>Call TestFn(Field1, field2)</P><P>or</P><P>TestFn Field1, field2</P><P>Perhaps that is the solution. See e. g. http://wiki.mcneel.com/developer/scriptsamples/parentheses</P><P>Rgds,<BR />Joachim</P></BODY></HTML> Tue, 15 Jun 2010 17:53:34 GMT https://community.qlik.com/t5/QlikView/Calling-an-Excel-macro-from-QV-or-vice-versa/m-p/189483#M52355 biester 2010-06-15T17:53:34Z