How to update references to a renamed Add-in

[John Broderick]

Hello all:

Say I created an Add-in (lets call it Original.xla) to hold some UDFs I use
quite a lot.
Say, I have used these UDFs in Test.xls.
I now want to rename Original.xla to New.xla and then make Test.xls
use the UDFs from New.xla?
If I simply rename the Add-in, remove Original.xla and install OurAddin.xla,
it does not work. Test.xls is still searching for 'Original.xla'.MyFunc.

Is there an easy way to tell Test.xls to use New.xla?

Thanks,
John

 

[John Broderick]

Hello all:

Say I created an Add-in (lets call it Original.xla) to hold some UDFs I use
quite a lot.
Say, I have used these UDFs in Test.xls.
I now want to rename Original.xla to New.xla and then make Test.xls
use the UDFs from New.xla.
If I simply rename the Add-in, remove Original.xla and install New.xla,
it does not work. Test.xls is still searching for 'Original.xla'.MyFunc.

Is there an easy way to tell Test.xls to use New.xla?

Thanks,
John

 

[Dave Peterson]

I _think_ that this will work.

Edit|Links|Change Source
(while test.xls is the active workbook)

 

[John Broderick]

Yes, that works.

Thank you.

I _think_ that this will work.

Edit|Links|Change Source
(while test.xls is the active workbook)