Updating Current Workbook with New Version Via Code?

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

The problem I face, is the users are all out in the field. They require use of the file when the are out and about. Now they can connect to our network if needed but it is not required for normal use. They do however need to connect to the network in order to update files.

I need to work around this when they are connected to the network...

Craig

So I did some testing and believe I came up with a solution for my needs.

I downloaded and opened the updated workbook (Book2) from the original workbook(Book1).

Set wb = Workbooks.Open(MyWBbook2)

Added a few cell references to the updated workbook(Book2) from Original Workbook(Book1).

wb.Sheets("MySheet").Range("A1").value = ActiveWorkBook.Name
wb.Sheets("MySheet").Range("A2").value = ActiveWorkBook.Path & "\"

I would add further information in Book2 for my real project to show the user the the update has been completed.
Then close the original workbook(Book1) from original workbook(Book1).

ThisWorkbook.Close SaveChanges:=False

This leaves only Book2 open ans since the user must click a button to open the userforms we use, I can then get the code to check for the cell references I added, if found, the code would delete the original file, move the new updated file to the proper folder and give the user a completed update message when finished. The user won't even know the workbook has changed.

I'm not sure if there is an easier way... but this seems to do the job!


Craig