| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
InStr GRRRRRRRR!!!!!!!!
 Who forgot about 'option base 1' at the top of the module and who was using 0 as the start position for the array comparison. Somedays, my stupidity astounds even me! The general help thing is that if you are using an index in a function is to ensure that the appropriate option statement is used at the top of the module. My InStr was wayyyyy down the code, completely forgot about Option... Thanks for looking anyway Andy -- 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
InStr GRRRRRRRR!!!!!!!!
Option Base has no effect on the index number used to refer to the first
element of a string - a string is not an array of characters like in C/C++ the first element of a string is always 1. so yes, your command should be If InStr(1, inputline3, fred, vbTextCompare) 0 Then regardless of your Option Base setting. -- Regards, Tom Ogilvy "andy_brit" wrote in message ... Who forgot about 'option base 1' at the top of the module and who was using 0 as the start position for the array comparison. Somedays, my stupidity astounds even me! The general help thing is that if you are using an index in a function is to ensure that the appropriate option statement is used at the top of the module. My InStr was wayyyyy down the code, completely forgot about Option... Thanks for looking anyway Andy -- 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 |
| Reply |
| 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 | |||
Hybrid Mode
