Workbook reference, search and replace not working?

[Razzy]

I got this as a string: "='C:\Users\Jones\Desktop\[test.xlsx]"

And want to replace "REPLACE_" in a workbook.

Like: "REPLACE_Sheet1'!$D$15

This will output a workbook reference: "='C:\Users\Jones\Desktop\[test.xlsx]Sheet1'!$D$15"

Questian: I cant get the search and replace function to work.

Dim HERE as string

HERE = "='C:\Users\Jones\Desktop\[test.xlsx]"

Workbooks("template.xlsm").Activate
Sheets("Sheet1").Select
    Cells.Select
    Selection.Replace what:="'REPLACE_'", Replacement:=HERE, LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

Why is it not working you think?

The code works with just text replacement:

Dim HERE as string

HERE = "='C:\Users\Jones\Desktop\[test.xlsx]"

Workbooks("template.xlsm").Activate
Sheets("Sheet1").Select
    Cells.Select
    Selection.Replace what:="'REPLACE_'", Replacement:="JUST TEXT", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

Later on I will build the replace part in a loop.

 

[Razzy]

It dont understand the replacement text: HERE = "='C:\Users\Jones\Desktop\[test.xlsx]"

 

[Razzy]

It works now fine, the fault was: It has to find a match in the sheet, and find the worksheet at the given path, otherweis it will just stop.