How to capture value in module
I have a value sitting in a standard code module I’d like my macro to access, what’s the best way to do that?

Your request is unclear. What do you intend to do with the value?

I'll warn you ahead of time that macros don't provide a way to pass info from one step to the next, other than the status code from the previous step. So you might not be able to do exactly what you wanted to do.