Hi team,

is it possible to write a macro to copy a network PERSONAL.xlsb into the XLSTART directory and replace the existing file in this location?

I have several users using a common PERSONAL.xlsb file, which i need them to manually copy and replace the file when I release an update - I would rather make this process automatic.

Perhaps this wont be possible to do as by virtue of running a macro the PERSONAL workbook will be open and locked from being modified/ removed?

Is there any other option open to me, can I point the excel application to a different directory for the PERSONAL workbook?

Cheers
Jordan