REPLACE issues

[dantheman9]

In some of my code I need to replace infomation in a string, which forms part of a file name as follows;
file name
Test Splits Data.txt
to be renamed;
Test Results.txt

stripedt = Replace(sFileName, "Splits Data", "Results")

However, sometimes the text file names are like this;
Test Splits Data(0000).txt

When running the replace code above it seems to also remove the (xxxx) value to, how can I keep it in is the file name has that value.

 

[Andrew Poulsom]

It didn't do that for me in Excel 2003:

Sub Test()
    Const sFileName As String = "Test Splits Data(0000).txt"
    Dim stripedt As String
    stripedt = Replace(sFileName, "Splits Data", "Results")
    MsgBox stripedt
End Sub

 

[Scott Huish]

Didn't do that for me in XL2007 either.

 

[dantheman9]

Oh,

both correct, sorry it was another issue in the code! but thanks for confirming with me.