I was wondering is there’s a way to run macro in .xlsx file? I need to run macro with a different file everyday but using the same macro. I tried to save the macro in a notepad and save it as .vb file.
Using excel application scope activity and invoke vb script activity to run the macro.
When I run it nothing happen to the excel which btw if I run the macro in the same file using .xlsm file it works.
But my everyday file is in this format:
Macro works only in this file using execute macro activity: