addin update error

[kdinardi]

I have this addin that I created for Excel that updates other user specific addins from our company server. However, for 2 out of the 8 addins, the program encounters an error on the addins("").installed=True line.


If chkReprint.Value = True Then
AddIns("Reprint").Installed = False
AddIns.Add Filename:= _
"\Server\Drivers & Applications\Add-Ins\Reprint\Reprint.xla"
AddIns("Reprint").Installed = True
End If

The only thing I can think of is that when I was trying to recreate the error, after a while the program stopped asking me if I wanted to overwrite the current file and started asking me about updating since the addin 'contains links to other data sources'. Yet one of the two addins that are acting up does not have any links to our network, or any other data sources. Any ideas on what the issue can be?

[si_the_geek]

Unfortunately "an error" comes up too often, and there is almost nothing we can do about it (apart from make rough guesses as to which of the many millions of errors it might be).

Errors have messages for a reason, and they are very good things - they tell us the problem, and from that we can work out the solution (or at least try to).