Thank you Alf. This will help.
I probably should have provided more detail when starting this thread. I have an Add-In that is used by various persons on a network. Occasionally I upload a new version of the XLAM and place in the same shared location. The users would rarely check the folder for updates so after a while their copy of the installed add-in is several versions old. I was thinking of having code in the Add-In on Workbook_Open, have it check if there is new version of the Add-In in the folder and if so, copy to the users Add-In folder, install & close the outdated version of the add-in. That way the end user would constantly be using the latest version without their input required.
Here is the code I have so far:
Obviously I don't want the code to return TRUE if there is only one XLAM with a similar name in the shared folder that has exactly the same name as the current add-in. (i.e. there will be multiple XLAMs in this folder. Some of them will be versions of this add-in, others will be unrelated add-ins. For the similar name test, the folder may contain the latest version & 1-2 previous versions of this XLAM. In this case, it would return TRUE. However if there is only one XLAM found with the similar name test and this XLAM file name is exactly the same as the ThisWorkbook then it would need to return FALSE). Any suggestions?
Bookmarks