Set old variable from a derived variable in VBA

Question

Would it be possible to set the find and replace text to whatever the new variable "path" is so that next time the macro runs it now looks for the new path instead of the original path from the first find and replace?

Sub Code()
ActiveDocument.ActiveWindow.View.ShowFieldCodes = True

Dim oldpath As String
Dim path As String
oldpath = ActiveDocument.path
path = Replace(orgpath, "\", "\\")

Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
    .Text = "C:\\Users\\Gianni\\Desktop"
    .Replacement.Text = path
    .Forward = True
    .Wrap = wdFindContinue
    .Format = False
    .MatchCase = False
    .MatchWholeWord = False
    .MatchWildcards = False
    .MatchSoundsLike = False
    .MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll

ActiveDocument.ActiveWindow.View.ShowFieldCodes = False
End Sub

I update a specific path of LINK codes in order to keep the objects active when the folder gets moved around. However, if I move the folder more than once, the macro above would break because it is searching for path A, the first. It replaces it with path B. But, if I want to move it again, searching for path B to get path C, it is still searching for path A.

Yes, dump it somewhere in the worksheet and then just retrieve it. — L42
– L42, Commented Feb 13, 2018 at 3:23
Word has a number of possibilities. What's not clear is when and from where the new path comes. Could you provide more information about the circumstances for the new path? — Cindy Meister
– Cindy Meister, Commented Feb 13, 2018 at 5:58

AJD · Accepted Answer · 2018-02-13 06:59:50Z

1

Set a Custom Property in the document to store the path. From memory: Document.CustomProperties is the collection you want to check and manipulate.

answered Feb 13, 2018 at 6:59

AJD

2,4682 gold badges15 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Set old variable from a derived variable in VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related