VBA Check for new workbook and replace current open book

Hi All

I am just playing around with a few ideas and have a workbook that I may want to distribute updates for.
I want the workbook to check to see if a new version exists in a different location on the network and close the open workbook copy the new version over it and then open the new version.


Logically this probably isnt possible however I though I would ask and see if it was or if there is a way around this.

The update would include new vba code and possibly forms and contents

thanks in advance

Dave

I would think you could do it with something along the lines of:
1. in the workbook open event of the "old version" put the check for a new version
2. if new version is found, open the new version
3. from the old workbook, call a macro you have put in the new workbook and pass the old workbook name/path
4. in the macro in the new workbook, close the old workbook, then save the new workbook over it

the two macros would be something like:

Please Login or Register  to view this content.

Thanks Yudlugar

I see where you were going with this, its a perfect soloution.

Thank you

The only thing I am missing is checking a version, I suppose I could have this on a hidden sheet in a cell.

Thanks again

Dave