Find and Replace

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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:
 
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:
 
Thanks very much indeed.
--
Thanks,
MarkN


Stefi said:
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:
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to find filename and replace 2
VBA code for pasting links -- modifying RDB code for summary workbook 10
Unwanted workbooks on startup 2
Find And Replace 3
Find and Replace in VBA 3
Find and Replace 1
Find and Replace and Update Links issue 5
Find/Replace MSWord wildcard characters from within Excel 6

Back
Top