Hi there... I have a workbook that has various areas that are updated automatically via code but once in a while the entire workbook needs to be updated (code change or something else that can't be brought in to the old workbook). I am trying to find a way to do this via code... I find that users either don't update or don't get around to updating without a push. So I would like to do this automatically via code.

I already have in place code that when the workbook is opened, it is moved to the proper folder and the original file location is removed. Now I am not sure if this is possible to do without the user having to do anything other than clicking the update button...

What I would like to do is:
  • Download the new file from the network (already know how to do this).
  • Replace the current file while it is still open.
  • Open New file.
  • Delete old file.


As I was typing this, I had an idea... would this work?
Download the file from the network, save file to proper folder, changing its name temporarily. Open the new workbook, run code from the new workbook that closes the original workbook and deletes it, then renames the new workbook.

Can something like this work? Any better ideas?

Thanks
Craig