Find and Replace links in a table

F

Flash in the Pan

What code would I need to lines in a table like this:

\\ABC_123\test.doc
\\ABC_123\test1.doc
\\ABC_123\test2.doc
and so on


with this

\\DEF_456\test.doc
\\DEF_456\test1.doc
\\DEF_456\test2.doc
and so on

this table is part of an access database file.
the info following the "\\" all changed exactly the same way
but the info after the "\" does not change plus theres no actual
pattern to the *.doc names.

the column header is FileName, and table name is Table1

Not only would the displayed text need to be updated but also the link
information.

I originally tried to do this manually using a replace command, the
displayed test would change but the hyperlink would not. This is why I
figure I would need to use a macro. I did something exactly like this
for an excel file using a macro that worked fine, but here I couldn't
figure out how to select a record.


Any help appreciated.


Thanks
 

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

Word macro that can call cells out of Excel for a find and replace 0
VBA word change keys 0
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
send XL text to word 3
Linking data in MS Word into Excel 5
Need help modifying code 0
Automatically change cover image when text changes 0
return without gosub error 0

Top