copying & linking entire workbooks

[Theresa]

How do I copy a workbook to a differnt folder and have it
update when the original is updated? This is due to the
people who need to see the file do not have access to the
folder where the original resides.

 

[Gord Dibben]

Theresa

I have never used the "Briefcase", but I believe it will do this.

An alternative.......

You can use VBA for this.

Sub BUandSave()
'Saves the current file to a backup folder and the default folder
'Note that any backup is overwritten
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs FileName:="E:\GordStuff\Backup\" & _
ActiveWorkbook.Name
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub

Stick the code into a general module and assign a button to it.

Alternatative.....place code into ThisWorkbook Before_Close Sub.

Will run whenever you close out that file.

Gord Dibben Excel MVP