Replace A Character Within A String

[Ark68]

cfn = ws_vh.range("B23")

cfn = "May-24 (Fri) schedule_1.xlsx"

I am looking for a vba solution to replace the "_1" with "_2" in this string.

 

[Ark68]

k9 = InStr(ws_vh.Range("B23"), "_") + 1
cof = Application.WorksheetFunction.Replace(ws_vh.Range("B23"), k9, 1, "2")

 

[Fluff]

Cross posted https://www.excelforum.com/excel-pr...ror-trying-to-set-a-workbook.html#post5124066

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Ark68]

Not really the same question Fluff. One was about the reason for an error when trying to set a workbook. This one was about how to replace a character in a string. Same macro, different problem. One problem cropped up after the first was solved.

 

[Fluff]

I would have to disagree, bth were about the same thing, ie changing the last value from 1 to 2.

 

[Ark68]

In the other post, the value had already been figured out how to change it to 2.
After the file name was changed, I needed a solution as to why I couldn't set that new name to ws_nwb.

Different.