How to Remove Or Replace a File in XLSTART Using VBA?

[ransomedbyfire]

I made an add-in for someone else using VBA. But I made it by making an XLS file and then setting the IsAddin property to true and placing it in C:\Users... \Microsoft\Excel\XLSTART.

Now, I need to replace the add-in with an updated file. But I can't figure out how to do this since the previous version will be running when Excel is opened other than to have the person manually put the new file in XLSTART. But XLSTART is hidden, and I don't want to have to explain to them how to get there.

How can I automate this?

Thanks!

 

[VoG]

I doubt that this is (easily) possible in code but maybe

Application.DisplayAlerts = False
'change the file
Application.DisplayAlerts = True

Untested and may well not work

Another way might be to close all files except ThisWorkbook then try.

 

[ransomedbyfire]

Hey, that's a pretty brilliant idea! I haven't tried it yet, but I will! Thanks!