Using a String in Evaluate function

Hi guys,

I'm trying to use this in conjunction with finding the local IP of a machine from source-code.biz which is the first part of the code below

Basically the IP is stored into 'IpAddrs' and I would like to use that in the Evaluate function further down.


First part

Please Login or Register  to view this content.

Now testing the concept of what I'm trying to do it works. I use the 'blues' string in place of 'IpAddrs' and I get 3 in A1 and the local IP in A2

Please Login or Register  to view this content.

Now if I try to use that in the below I get a run time error 13 - type mismatch. A1 was a placeholder while I worked out chopping up the IP. Basically it looks at the first block of the IP (before the first . ) and the second block is between the first and second . of the IP. I am trying to replace the $A$1 section of the evaluate with the IpAddrs string.

Please Login or Register  to view this content.

Originally Posted by JBeaucaire

IP strings are not typically declared as INTEGER, they are typically declared as STRING.

In my clumsy troubleshooting I did try replacing all of the integers with String but it resulted in the same mismatch error

Further to it. I believe it has something to do with the IpAddrs string

For example if I put the value of IpAddrs into range F1 and then say TestV is equal to the value of F1... it works fine

Please Login or Register  to view this content.