Hi Matthew, you could set a custom property on every converted book,a nd
check for that property before doing the "replace =" thing.

Jens
--
http://ManagedXLL.net/
Replace MSDN with my first name when replying to my email address!


"Matthew Wieder" wrote in message
...
Hi - thanks for the proposed work-around. It seems like it will work,
but how do I stop the "replace =" code from executing every time it
opens? If I have a clause like you say that checks for whether the
LinkSources collection references the new add-in, then the code will
execute for any and all excel workbooks, not just ones which had links
to our old add-in; workbooks executing our code would be optimized, but
all other workbook swould be really slow every time...

Jens Thiel wrote:

Hi Matthew,

I think the XML dump is different from the default XLS file format.
Experience (and the SDK docs) show that workbooks are keeping a
reference to
XLAs. Renaming the XLA to XLL is something different here as Excel can
recognize the file format. You could as well move the XLA to the XLSTART
folder (and that's what I suggest - you will run into different problems
otherwise).

You do not need to update all workbooks manually. Simply implement the
code
to update the worksheets in your new XLA. It has to be done only for
workbooks that do not reference your new XLA in the LinkSources
collection.
Solutions like this are implemented on even the largest sites...

Jens.