Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace
Hello,
I have a load of workbooks in different locations where the location of one of the links has changed. I'm not sure how to go about this but what I want to be able to do is -select a workbook but not be prompted to update links -find any formulas with links including "Z:\" and replace with "F:\" anywhere in the workbook. -- Any help appreciated, MarkN |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace
You can use Edit/Replace/Options/Search in formulae/Replace all, but I don't
know any way to switch off prompt to update links. Regards, Stefi €˛MarkN€¯ ezt Ć*rta: Hello, I have a load of workbooks in different locations where the location of one of the links has changed. I'm not sure how to go about this but what I want to be able to do is -select a workbook but not be prompted to update links -find any formulas with links including "Z:\" and replace with "F:\" anywhere in the workbook. -- Any help appreciated, MarkN |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace
I found a method: if you open the workbook from VBA like this
(UpdateLinks:=0) then it will not prompt to update links (this is of course only an example file name): Workbooks.Open Filename:= _ "C:\Documents and Settings\Csosz\Dokumentumok\newsgroup\bongard.xls" , _ UpdateLinks:=0 Regards, Stefi €˛Stefi€¯ ezt Ć*rta: You can use Edit/Replace/Options/Search in formulae/Replace all, but I don't know any way to switch off prompt to update links. Regards, Stefi €˛MarkN€¯ ezt Ć*rta: Hello, I have a load of workbooks in different locations where the location of one of the links has changed. I'm not sure how to go about this but what I want to be able to do is -select a workbook but not be prompted to update links -find any formulas with links including "Z:\" and replace with "F:\" anywhere in the workbook. -- Any help appreciated, MarkN |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace
Thanks very much indeed.
-- Thanks, MarkN "Stefi" wrote: I found a method: if you open the workbook from VBA like this (UpdateLinks:=0) then it will not prompt to update links (this is of course only an example file name): Workbooks.Open Filename:= _ "C:\Documents and Settings\Csosz\Dokumentumok\newsgroup\bongard.xls" , _ UpdateLinks:=0 Regards, Stefi €˛Stefi€¯ ezt Ć*rta: You can use Edit/Replace/Options/Search in formulae/Replace all, but I don't know any way to switch off prompt to update links. Regards, Stefi €˛MarkN€¯ ezt Ć*rta: Hello, I have a load of workbooks in different locations where the location of one of the links has changed. I'm not sure how to go about this but what I want to be able to do is -select a workbook but not be prompted to update links -find any formulas with links including "Z:\" and replace with "F:\" anywhere in the workbook. -- Any help appreciated, MarkN |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace
You are welcome! Thanks for the feedback!
Stefi €˛MarkN€¯ ezt Ć*rta: Thanks very much indeed. -- Thanks, MarkN "Stefi" wrote: I found a method: if you open the workbook from VBA like this (UpdateLinks:=0) then it will not prompt to update links (this is of course only an example file name): Workbooks.Open Filename:= _ "C:\Documents and Settings\Csosz\Dokumentumok\newsgroup\bongard.xls" , _ UpdateLinks:=0 Regards, Stefi €˛Stefi€¯ ezt Ć*rta: You can use Edit/Replace/Options/Search in formulae/Replace all, but I don't know any way to switch off prompt to update links. Regards, Stefi €˛MarkN€¯ ezt Ć*rta: Hello, I have a load of workbooks in different locations where the location of one of the links has changed. I'm not sure how to go about this but what I want to be able to do is -select a workbook but not be prompted to update links -find any formulas with links including "Z:\" and replace with "F:\" anywhere in the workbook. -- Any help appreciated, MarkN |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Using Find and Replace to replace " in a macro | Excel Programming | |||
Replace method - cannot find any data to replace | Excel Programming |