EXCEL, given a string, search and delete string inside TXT file.

See more:

MS-Excel

string

text

search

In an EXCEL file, you type in a cell a number, then it looks for said number in a TXT file, then deletes said number from the txt file, or if not found, it pops out a message saying it was not found.

What I have tried:

I found this:
Dim Findstring = IO.File.ReadAllText("Your File Path")
Dim Lookfor as string = " " #Need specified cell

If FindString.Contains(Lookfor) then
Msgbox("Found: " & Lookfor)
end if

but it's a visual basics code, gives me error.
and still needs to delete found string.