Hi There,Im using the code below to search for BiosDate in a particular textfile.The problem im getting is the fact that there are more than 1 bios date and i only need the first instance.What can i add to this code to only return the first instance of BIOS Date?
Thanks!
If InStr(1, GetLine, "BIOS Date"
> 0 Then 'Search for date
ActiveCell.Offset(b, 2) = "TRUE"
ActiveCell.Offset(b, 2).Value = GetLine
ActiveCell.Offset(b, 2).Value = Trim(Mid(ActiveCell.Offset(b, 2).Value, Len("BIOS Date: "
, 15))
b = b + 1
End If
Thanks!
If InStr(1, GetLine, "BIOS Date"
ActiveCell.Offset(b, 2) = "TRUE"
ActiveCell.Offset(b, 2).Value = GetLine
ActiveCell.Offset(b, 2).Value = Trim(Mid(ActiveCell.Offset(b, 2).Value, Len("BIOS Date: "
b = b + 1
End If