How to update .xlam file (add-in) while it is in use?
I'd try marking the tool.xlam as Readonly using windows Explorer.
But then I'd have to update my copy (in a different location). But that makes
sense to me. I'd be able to test or pause and come back to it without
disturbing anyone.
Then when it's finished, I could change the Readonly mark to read/write and
quickly(!) overwrite the file with my development copy of the addin.
Then mark it readonly once more.
If I recall correctly, I used to do this when we used xl2k. But you'll want to
do some testing to see if it works ok for you.
Mathieu936 wrote:
Hi!
I created an add-in in Excel 2007 (tool.xlam). I will have about 75
users using this add-in.
I know if the add-in file is in use (i.e. someone have Excel opened
and the add-in is installed), I can't update the file.
I will have to frequently update my add-in, and I don't want to ask
everyone to close excel to access the file.
Is there a way to share the xlam file or code it in a specific way?
Thanks!
--
Dave Peterson
|