How to run Macro in another Macro-enabled workbook without opening that file?


#1

Hi guys, I’m running a macro to execute on a working file. That macro is stored in another “helper” workbook (in the future I might store multiple macros in that workbook).

I wanted to know how to execute that macro without opening the macro-enabled file. Any workarounds? :slight_smile:


#2

Hi @TheCProject

You can always use Invoke VBA activity and store your code in a simple .vbs file (irrespective of the other macro-enabled file).
In fact, I use this method to store all my functions in one file, because Invoke VBA activity has a parameter to decide which function to call :slight_smile: