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. ...
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.
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?- The difference is:
It had been working for me as had been recommended.
Then it stopped.
You have suggested that it could not have worked in the first place.
So, we differ and I don't know how to resolve that.... so I asked.