Changing Links
 

I have a link on one of my worksheets:
='\\ahfctor01\ahfcsharedfiles\Branch and
Corporate\Corp\[Region108BARModel.xls]RegionalControl'!$F$11
I then have a macro that goes in and updates F11 and saves, but this changes
the link. How come? This is the code:

Workbooks.Open Filename:=netwrkpath
Sheets("RegionalControl").Range("f11").Value = "IN PROCESS!"
ActiveWorkbook.Save
ActiveWorkbook.SaveAs Filename:=netwrkpath2
Application.Run (macrname)
Application.Run (macrname)

The link switches to netwrkpath2, I would like to have it continue referring
to the first file. Can I accomplish that without re-writing the formula?

Thanks!
--
Paul