<div>
as default its compare option is vbTextCompare
</div>


as default its compare option is vbTextCompare

<div>
Cheers, that worked. &nbsp;
</div>


<div>
<div class="content wysiwyg-content">
I am looping through an array called strLines to find strDelete. &nbsp;If strDelete is not there, i am writing strLines(i) to a text file.<br />
<br />
However, if strDelete is contained within strLines(i) - i want to replace strDelete with &quot;&quot;&nbsp;&amp; then write the line.<br />
<br />
The code i have is as follows:<br />
<br />
For i = LBound(strLines) To UBound(strLines)<br />
&nbsp; &nbsp; If strLines(i) &lt;&gt;&nbsp;strDelete Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; Write #1, strLines(i)<br />
&nbsp; &nbsp; End If<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; pos = InStr(0, strLines(i), strDelete, vbTextCompare)<br />
&nbsp; &nbsp; If pos = 0 Then &nbsp;//not in strLines(i)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Write #1, strLines(i)<br />
&nbsp; &nbsp; Else<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;strLines(i) = Replace(strLines(i), strDelete, &quot;&quot;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Write #1, strLines(i)<br />
&nbsp; &nbsp; End If<br />
Next<br />
Close #1<br />
<br />
<br />
The error I'm receiving is runtime error 5: Invalid procedure call or argument on line: &nbsp;pos = ......<br />
<br />
<br />
Any suggestions please?
</div>
</div>


I am looping through an array called strLines to find strDelete.  If strDelete is not there, i am writing strLines(i) to a text file.

However, if strDelete is contained within strLines(i) - i want to replace strDelete with "" & then write the line.

The code i have is as follows:

For i = LBound(strLines) To UBound(strLines)
    If strLines(i) <> strDelete Then
        Write #1, strLines(i)
    End If
    
    pos = InStr(0, strLines(i), strDelete, vbTextCompare)
    If pos = 0 Then  //not in strLines(i)
         Write #1, strLines(i)
    Else
         strLines(i) = Replace(strLines(i), strDelete, "")
         Write #1, strLines(i)
    End If
Next
Close #1


The error I'm receiving is runtime error 5: Invalid procedure call or argument on line:  pos = ......


Any suggestions please?

Using the Instr Function

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.