View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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