append a file after finding a string in VB

[pujas]

Hi,

I want to append a line into a file after i find this string " </title>" in the file.
Any ptrs will greatly be appreciated.

Also can someone tell me how do i escape " in a string
I want to store a string with " in it
eg

Dim strRet As String
strRet = "<A HREF="XYZ/Main.txt">ABC</A>"

i tried
strRet = "<A HREF=\"XYZ/Main.txt\">ABC</A>"
but it did not work

Thanks

 

[fumei]

As this is a VBA forum, are you talking about appending a line into a Word file?

You can use Chr(34), as in:
strRet = "<A HREF=" & Chr(34) & "XYZ/Main.txt" & _
Chr(34) & ">ABC</A>"



Gerry

 

[PHV]

You may also use this syntax:
strRet = "<A HREF=""XYZ/Main.txt"">ABC</A>"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244