Heres an Easy 1!

[Newbie311]

Hi There,
I just need to modify the following code to display the first value it finds.I.E there are 2 bios dates in a text file however i just need the first instance.P.S currently the statement below returns me 2 instances of bios date and i only require the first 1 found!
Much Appreciated if you can help!
Thanks

If InStr(1, GetLine, "BIOS Date&quot > 0 Then 'Search for Bios Date

ActiveCell.Offset(b, 2).Value = GetLine
ActiveCell.Offset(b, 2).Value = Trim(Mid(ActiveCell.Offset(b, 2).Value, Len("BIOS Date: &quot, 15))
b = b + 1



End If

 

[sdraper]

If InStr(1, GetLine, "BIOS Date&quot > 0 Then 'Search for Bios Date

ActiveCell.Offset(b, 2).Value = GetLine
ActiveCell.Offset(b, 2).Value = Trim(Mid (ActiveCell.Offset(b, 2).Value, Len("BIOS Date: &quot, 15))
b = b + 1
Exit Sub



End If
adding exit sub to the above might work for you...

Sam