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