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?
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?