I have a different kind of macro functions in a separate file like (Marco.xlsm)
Based on the input file, i want to call the correct macro function.
Is this possible to run the macro function in .xlsx format.?
If yes, please give the solution.
For Example: - If i call the Macro Function from the Macro.xlsm file, the changes will be happened in .xlsx file.
Thanks in advance.