|Excel Developer Reference|
expression A variable that represents a Workbook object.
This method is useful when a workbook is opened as read-only by user A and opened as read/write by user B. If user B saves a newer version of the workbook to disk while user A still has the workbook open, user A cannot get the updated copy without closing and reopening the workbook and losing view settings. The UpdateFromFile method updates the in-memory copy of the workbook from the disk file.
This example updates the active workbook from the disk version of the file.
|Visual Basic for Applications|