Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop Link Update
I am using three workbooks- a master control workbook, a back-up copy and a
working copy. The following code open the back-up copy, changes it to in Process and then opens the working copy. Works fine- my problem is that there is a link in the master control workbook that refers to a value in first copy. On the second save Excel automatically updates the link in the master file to refer to the second save. How can I make the link static? Code in use: Workbooks.Open Filename:=netwrkpath Set branchbook = ActiveWorkbook Sheets("RegionalControl").Range("f12").Value = "IN PROCESS!" ActiveWorkbook.Save ActiveWorkbook.SaveAs Filename:=netwrkpath2 '(THIS STEP IS WHERE THE LINK IS SWITCHED) Application.Run (macrname) -- Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't stop the Update Links? startup prompt | Excel Discussion (Misc queries) | |||
Formula - stop the update | Excel Worksheet Functions | |||
Insert Row - Stop Automatic Formula Update | Excel Worksheet Functions | |||
Chosen not to update links but they are updated anyway. How stop? | Excel Discussion (Misc queries) | |||
More UDF problems; some won't update, some won't stop running! | Excel Programming |