All,

Many Thanks for the brain food... ive had a play, the closest ive got
to getting this working is using BACs script.

AddIns("Your Addin Title").Installed = False 'To remove current link
AddIns.Add Filename:= _
"\\servername\AddinDirectory\Y*ourAddin.XLA"
AddIns("Your Addin Title").Installed = True


But, i get a "subscript out of range" on line #1. i comment it out. so
it goes to line #2. where it prompts me to add and overwrite the
existing file. Thats a good thing. it means the network version is
being copied over the local version.
Then i get a subscript error again on line #3.

The "Your Addin Title" name seems to be the correct. in the XLA under
properties/project name, ive called it "ExcelSiteLibrary3".
if i add this manually and tick it in references, the name is the same
"ExcelSiteLibrary3".

So the Step #1 and #3 or unticking and ticking the reference name in
theory should work.

Any more food for thought.
Again Many Thanks for all your help :)

Arty.