Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA.Drafting.Text.Replace 1

Status
Not open for further replies.

Aleksan

Mechanical
Dec 8, 2005
8
All,
With risk of rolling eyes on “I looked here and there and couldn’t find…”, I have to ask…

What is VBA code to replace few characters in string with another? Search for BOB, replace with SAM after “Set drawingText1 = drawingTexts1.Item(i)”. Ex: “I am BOB, ey?” to “I am SAM, ey?”
I haven’t been here for a while and out of touch with VBA, but kinda need this now…

Ferdo, thank you for all your contribution on the forum. Priceless.

Thank you all.
 
Replies continue below

Recommended for you

sNewString = replace(sOldString,"replace","with")
 
Got it. Works.
Everything is simple when you know how...
Thank you very much, PeterGuy!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor