InStr GRRRRRRRR!!!!!!!!

  • Thread starter Thread starter andy_brit
  • Start date Start date
A

andy_brit

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 :confused: Andy Clarke
 
:eek:

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

code 1
sending from outlook2007 to mac mail produces garbage 20
I delete this code and it automatically comes back... 8
ReadXML error 5
Add a META line to an existing HTML doc programmatically 2
What's this and do I need it? 11
W3C validator 7
gridlines toggled off when importing html table 0

Back
Top