Excel VBA to find and replace in a text file, ignoring "".

[Matt-C]

Hi,

I have copied a marco from a website which finds text in a .txt file and replaces it with another text string,

Sub TestFindAndReplace()
  On Error GoTo ErrorHandler
  Call FindAndReplace("C:\test1\testfile.txt", "123", "abc")
ProgramExit:
  Exit Sub
ErrorHandler:
  MsgBox Err.Number & " - " & Err.Description
  Resume ProgramExit
End Sub

it works fine when i just look for "123" and replace with "abc" but if i try and look for

[IMG]http://www.mrexcel.com/forum/../CL300/images/Back-button-V2-web_000.gif[/IMG] BORDER="0">

and replace with

it dosent like it, how can i make it to ignore the " "?, because thats where vba brings up an error in the code.

Thanks

Matt

 

[tweedle]

without seeing the underlying code...
you could try searching for

 "[ IMG ]http://www.mrexcel.com/forum/../CL300/images/Back-button-V2-web_000.gif[/IMG] BORDER=" & char(34)  & "0" & Char(34) & ">"CODE]