Calling subroutine in closed workbook without opening

Hi all,

Is it possible to call subroutines in a closed workbook without opening it?

Thanks - Niels

The only thing I can think that might help is using a Personal Macro Workbook https://support.microsoft.com/en-us/...1-ae005a9bc790 this way you don't need to access a closed workbook you simply have a shared macro library, so to speak.

Perhaps other ideas could be had if you could explain the process, you are trying to automate with the current macro.

OK, it was just an idea about how to organize my files and in which ones to contain the code. I guess I will figure it out.

Thanks:-)

You could open the workbook containing the macro, as a hidden workbook, and then run the macro, and finally close the hidden workbook again...
...that way the user will never know or see what is happening.