Hi I'm using XP Pro
Why-oh-why will this bit of code not bloomin well work!
If InStr(0, inputline3, fred, vbTextCompare) 0 Then
etc etc etc
end if
0 is my start position
inputline3 is dimmed as a string,
sample data: <html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns="http://www.w3.org/TR/REC-html40"
....all as one line
fred (every program needs one) is also dimmed as string.
sample data <!--Title--
It sits within a procedure that crawls through a 1 dimensional string
array line by line looking for a trigger within a line of data.
the array contains html as seen which is read in as text. the html
contains all sorts of characters such as quotes, colons '<'s and '''s
!'s and --, probably all illegal characters for excel. I'm searching
for a particular string within a line of html so that I can go off and
do stuff.
I'm sure I got the instr syntax right, but i keep getting a run time
error 5, invalid procedure call or arguament
Could somebody please put me out of my mysery.
I hate when simple stuff like this trips me up
Thanks
Andy Clarke
--
andy_brit
------------------------------------------------------------------------
andy_brit's Profile:
http://www.excelforum.com/member.php...o&userid=28002
View this thread:
http://www.excelforum.com/showthread...hreadid=475054