can't update a master add-in!

[adds007]

Hi,
I have never worked with add-in before and I am having problems. I am using a master add-in to reference code for over 100 files. I know how to install the add-in and it's reference by VBA. But when I update the code in master add-in (which btw gives a pop-up "xxx.xla is already open" when I open it), all other files reference the old add-in and are not updated by master add-in. Below is my WorkbookOpen event code: What am I doing wrong?

Please Login or Register  to view this content.

[adds007]

Ok, I did some research and figured I update you guys with some more info.
I read upon forums and realized that:
1) in VBA, add-in has to uninstalled
2) close excel
3) deleted from Application Data folder
4) open excel
5) in VBA, install the add-in again by file from shared drive of the more updated version

I don't understand how I am supposed to do all this in VBA. I mean how can I delete file while Excel is closed from VBA. Below code doesn;t work

Please Login or Register  to view this content.

How do i update my add-in code to all computers referencing it?

[adds007]

I didn't find an efficient solution for this, so i decided let all the file reference the same add-in on a shared network space
Thanks for viewing