Thanks!

It works great!


Code:
--------------------
Sub auto_open()
' For Auto Updating Linked Files
Application.ScreenUpdating = False
Workbooks.Open Filename:=ActiveWorkbook.Path & "\Test_file_02.xls", UpdateLinks:=1
ActiveWorkbook.Close True
Application.ScreenUpdating = True
End Sub
--------------------


It updates without a flicker. "Test_file_02.xls" closes when "File 1"
opens to run the "auto_open" macro. You can move the files from folder
to folder without a hitch. It works great.

Again Thanks alot.


--
joopdog
------------------------------------------------------------------------
joopdog's Profile: http://www.excelforum.com/member.php...o&userid=31336
View this thread: http://www.excelforum.com/showthread...hreadid=510162