Go to one of the 4 files and in the VBE, create a reference to the linked
workbook.

then whenever file (one of the 4) is opened, the linked file will be opened
automatically. You will not be able to close it until the file (one of the
4) is closed.

that may not be a solution for you, but is offered as a consideration.

--
Regards,
Tom Ogilvy


"jeffcravener" wrote:


I have an Excel file that is linked to 4 other excel files.

These other excel files have VBA code to automate putting data into the
cells.

But, i have to open up the one that is linked to the other 4 each day
manually to update the links.

Is there a way to do it in code?

Thanks in advance!


--
jeffcravener
------------------------------------------------------------------------
jeffcravener's Profile: http://www.excelforum.com/member.php...info&userid=99
View this thread: http://www.excelforum.com/showthread...hreadid=530895