Macro to update documents

[CHSLax60]

Here is my scenario.
I have different workbooks in different places on a server (we'll call them DocA & DocB) that have a cell that links to a cell in a master workbook (we'll call it Doc1). The value of that cell in Doc1 changes values in tables in DocA & DocB. And there are cells in Doc1 that link to those tables in DocA & DocB.

What I want to do is be able to change the value in that cell in Doc1 and have a macro button that would open DocA & DocB to update their tables so the data can be pulled back into Doc1.

If I could force the DocA & DocB to close automatically that would be an added bonus.

 

[Arcticwarrio]

sub saveit()
Workbooks.Open Filename:= _
"c:\DocA.xls"
Workbooks.Open Filename:= _
"c:\DocB.xls"
Workbooks("DocA.xls").Sheets("Sheet1").activate
ActiveWorkbook.Save
ActiveWindow.Close
Workbooks("DocB.xls").Sheets("Sheet1").activate
ActiveWorkbook.Save
ActiveWindow.Close
end sub