Forum Discussion
Setting up a common subroutine(s) module/reference in Excel VBA
I need to have a common set of subroutines that can be used in .xlsm files while assuring subroutine consistency from one target file to another. I have done this successfully just very recently. ...
I'd either save the code in your personal macro workbook PERSONAL.XLSB, or in a workbook that you save as an Excel Add-in (*.xlam). If you choose the latter, activate the add-in in File > Options > Add-ins.
Yes, I had considered the various options and decided that this would work best in our situation. Of course, that doesn't mean I couldn't revisit that idea and try again.
- Unfortunately, the expected item isn't shown in the Tools/References list.
why you need them shown in Tools/Reference.
Only com active class items with Registry entries can be showed here.
Vba xlam or xlsm are not com class so they are not showed.- pieyezhu: Well, I can see that you know more about the mechanics of this than I. However, this process was recommended and *had* been working. How do we reconcile the difference?
- Re:How do we reconcile the difference?
Sorry,I am not good at English?
What do you mean reconcile the difference?
