View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default Cannot copy addin locally error?

Two possible problems, but one is more likely than the other... Lets start
there. Someone attached to the addin, but instead of making a local copy they
are attached to it directly. They have it open and this gives them exclusive
access as far as Excel is concerned. Find out who is holding it and get them
a local copy. The other much more remote possiblitiy is that they do not have
write access to their addins directory. This is a long shot but hey you never
know... Those are my bright ideas on the subject...

HTH

"R Avery" wrote:

I have an addin on the public drive which I need others in the company
to use. On one particular computer, when I do Tools | Add-ins |
Browse, choose the file, it prompts me for whether or not i want to
copy it locally. I press yes, then I get the following error in a
MsgBox with only an OK button:

"Unable to copy add-in to library."

When does this happen? How do i fix it? I could just copy the add-in
manually, but the point is that I care what causes the above error.