How to update references to a renamed Add-in
 

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

How to update references to a renamed Add-in - Corrected
 

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

How to update references to a renamed Add-in - Corrected
 

I _think_ that this will work.

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



John Broderick wrote:

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

How to update references to a renamed Add-in - Corrected
 

Yes, that works.

Thank you.

"Dave Peterson" wrote in message
...
I _think_ that this will work.

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



John Broderick wrote:

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