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"
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 ?