If that is a sub, you can't call it from a macro or anything else that requires use of a function. Since it looks like a click event for some control, and such events are subs, not functions, that would be an issue. If you need to run a sub, you'll have to create a function and use it to call the sub.
Did you consider task manager to initiate the process according to your needs?
I don't have your db or fully understand the process, but I have done a similar sort of thing before, and the only macro I needed was AutoExec so that it would run when the db opens. Apart from that, there were no other macros - all functions and subs, all automated.