| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
InStr GRRRRRRRR!!!!!!!!
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with VBA InStr() function | Excel Discussion (Misc queries) | |||
| InStr | Excel Programming | |||
| InStr | Excel Programming | |||
| InStr and ADO | Excel Programming | |||
Threaded Mode
