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

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

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

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

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