I figured it out, I changed the number of characters it is capturing in my string manipulation
intRight = Len(strCurrentLine) - 3
changed to
intRight = Len(strCurrentLine) - 8
Thank you for all your help... great forum by the way
I went through the regular expressions syntax... The best I could gather was that I need an "anchor"
I do not understand the regular expression code so I am not sure what to add to get it to "Overtype" instead of pushing the text over
Wow, I dont understand that code at all but it seems to work!! The only thing I need it to do now is insert the text over the old text instead of indenting and pushing it over.
Thank you so much! I wonder if you happen to know how I can change it to insert the text and overwrite?
I read a few posts discussing Regular Expressions, in all cases it was searching for filenames with wild cards and I do not understand how to apply it.
Can someone tell me how I would insert a regular expression to solve this issue?
Const ForReading = 1
Const ForWriting = 2
Set objDialog =...
I am searching a huge text file for the following text;
3**40**
Where the * represents a wild card
How do I manipulate this line of code to search for this?
if InStr(226, strCurrentLine, "3**40**", vbTextCompare) = 226 Then
Thank you,
Steve
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.