It would be a separate program -- the sort of thing that runs when you install
some new software. It would copy your XLA to the correct directory, make any
changes to the registry that are needed, maybe open Excel behind the scenes
and remove the old item from the add-ins list and add the new one, etc. Folks
often buy software that write the installer program for them.

On Wed, 13 Oct 2004 10:49:09 -0400, Matthew Wieder
wrote:

I don't need help coding the install routine, I just don't understand
what your suggestion is...

Myrna Larson wrote:
No, I can't, because I've never done it. I'm just a lone, retired user,
working on stuff on my own local PC, not on a network.

But I'm sure there are folks here that can help with that.

On Tue, 12 Oct 2004 15:35:48 -0400, Matthew Wieder
wrote:


thanks for trying. Could you give more detail about the solution you
suggested of "develop an installer routine that removes the XLL, and
installs the XLA" - how would that work?

Myrna Larson wrote:

RE the code below: It ran without an error, and Rng.Formula does return a
variant array with the formula for each cell, but after presumably just
replacing them, I had #NA! errors all over the place. i.e. the formulas

were

TOTALLY screwed up! It won't work, I guess.



The following simplified code worked for me without an error:

Set Rng = ThisWorkbook.Worksheets(1).UsedRange. _
SpecialCells(xlCellTypeFormulas)
Rng.Formula = Rng.Formula

That should run MUCH faster than a loop.