Update Feature using VBA

[FoRmEd]

Is this possible? Small description:

Create an update button for users to click and update the workbook. The reason for this; there is a settings page that needs to migrate to the newer version (an update gets added to workbook so I release a newer version) because it can be quite annoying to re-enter your settings each week or month.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>

• Click “Update” on older version.
  • The newer version pulls up and migrates Settings info
  • The old version closes
  • New version saves and overwrites old version.
• User is now starring at the new version of the workbook.

<o> </o>
Is that at all possible?

 

[FoRmEd]

I take that as a yes. Ok, I will post the code after I have tested it.