Updating a copied workbook with data from the original

**simonlblea** · 04-10-2013, 08:00 AM

Hi,

I have a workbook that I wish to keep in my documents, however I have made a copy for my manager on our shared network drive. I would like the copy in the shared folder to update every time I make changes to the original.

Is there a way of doing this?

Thanks

**AndyLitch** · 04-10-2013, 08:17 AM

Please Login or Register  to view this content.

The second sub saves two copies of the workbook.
The second sub should go in the This workbook module and will save automatically on close.

**simonlblea** · 04-10-2013, 08:25 AM

Hi, thanks for coming back to me. Sorry if I appear a little thick, but what do I do with the code?

**AndyLitch** · 04-10-2013, 08:33 AM

1. Open your workbook.
2. Right click on a worksheet tab and select "View Code"
......... The window will now switch to the VB editor.
3. Find your Vb project in the project explorer window (which should be to the left) and will have the same name as your workbook.
4. Right click on the project and select "Insert Module"
5. Double click on module 1
6. Paste the code for the sub savebook into the module
7. Insert a shape onto your worksheet
8. Right click on the shape and select "Assign macro"
9. Select the save macro from the list
10. Edit the blue and red lines in the code above for the correct filenames... Put the managers on top (blue) and then your file(red).

Now every time you click the shape the workbook will be saved to both locations.