Change Word Links via VBA ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mario Reiley - 21 Feb 2005 14:46 GMT

Hello Group,

I have a document in Word with Bonds to Excel. I need to change statements I
link using VBA.

For example:

My old Source Path
"C:\Source Project\My file.doc"

My New Source Path

and I want to change a part to
"C:\New Project\My file.doc"

Any advisor will be Wellcome

Best Regard
Mario

Reply to this Message

Jean-Guy Marcil - 21 Feb 2005 15:59 GMT

Mario Reiley was telling us:
Mario Reiley nous racontait que :

> Hello Group,
>
[quoted text clipped - 10 lines]
> and I want to change a part to
> "C:\New Project\My file.doc"

Display all field codes, then find/replace all "C:\Source Project\" with
"C:\New Project\".

'_______________________________________
Application.ScreenUpdating = False

ActiveWindow.View.ShowFieldCodes = True

With Selection
.Find.ClearFormatting
.Find.Replacement.ClearFormatting
With .Find
.Text = "TIME"
.Replacement.Text = "DATE"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
.Find.Execute Replace:=wdReplaceAll
End With

ActiveWindow.View.ShowFieldCodes = False

Application.ScreenUpdating = True
Application.ScreenRefresh
'_______________________________________

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Reply to this Message