Qualifying sub names

B

Bura Tino

Hi,

I used to have a workbook that my colleagues used, and now I converted it to
an add-in. I kept all the sub names, but renamed to the toolbar that calls
them. Now when my colleagues use both the add-in and the old workbook (not
that they should) the new menu calls subs from the old workbook. Is the a
way to say "use subs from ThisWorkbook"?

(I could always renames all the subs, but that's a bit of a pain).

Thanks,

Bura
 
N

Nigel

Prefix the call will the name of the work book if you have a sub called
Test() in both open workbooks then:-

Call Book1!Test
Call Book2!Test

If they are in the different modules try

Call Book1!Module1.Test
Call Book1!Module2.Test

Cheers
Nigel
 
B

Bura Tino

Nigel said:
Prefix the call will the name of the work book if you have a sub called
Test() in both open workbooks then:-

Call Book1!Test
Call Book2!Test
Click to expand...

The problem with this is that I'm developing the adding as an regular XLS
file (MyAddin.xls) and then saving it as an add-in (MyAddin.xla). I'm
guessing that would break the links you are suggesting.
 
Top