Whenever you are trying to run a macro with EXECUTE MACRO activity then the specified excel file must be macro enabled and I could see you have mentioned as .xlsx
Is it .xlsx file or xlsm or xlsb
Please validate that once
Or
Try calling in this way
Hi all,
I am trying to use the Execute Macro activity to run a macro from my Personal Macro Workbook (PERSONAL.XLSB), but I encounter an exception, which I’ve included below.
My input field for Execute Macro is as follows, where “JobsheetExport” is the macro name:
“C:\Users\Daniel\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB!JobsheetExport”
Here’s part of the error message (if the full message helps, I can post that too):
Message: The range does not exist
Source: Execute macro
Ex…
Cheer @gitesh.bhoir
1 Like