I have this piece of Code:


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


When I run this code from "File 1" everything updates automatically,
great.
However, "File 2" remains open. Is there away to close the file?

Any help would be appreciated.


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