Sharing Macros With Modules

[audioboxer]

Hello - I'm using regex in a macro and need to share it with others. Will the receiver be able to use it without having to enable the reference in the VBA Editor? The user(s) are not computer literate.

While I am at it, is it possible for someone to add an add-in without enabling the developer option and then enabling the add in? Trying to think of the best way to share a macro with illiterate computer users.

Thank you

 

[rlv01]

Hello - I'm using regex in a macro and need to share it with others. Will the receiver be able to use it without having to enable the reference in the VBA Editor? The user(s) are not computer literate.

If your code uses early binding for the regexp object, then no. If you code uses late binding, e.g.

        Set RObj = CreateObject("VBScript.RegExp")

then maybe.

Trying to think of the best way to share a macro with illiterate computer users.

Speaking from painful experience, don't even try. The best way to share a macro with illiterate computer users is to give them a worksheet with a nice big "Run Macro" button on it.

 

[GWteB]

While I am at it, is it possible for someone to add an add-in without enabling the developer option and then enabling the add in?

Yes, that's possible. In that situation (without installing de AddIn) you have to take into account that the AddIn is not automatically available with every start of Excel. The user has to open the AddIn manually, unless the code in your workbook arranges this. AddIn macros have to be launched with the Application.Run method.

 

[audioboxer]

Thank you both, I completely forget about early/late binding. I’ll just share it as macro enabled workbook with a big “Run” button.

 

[GWteB]

You are welcome & thanks for letting us know.