search html source code and return a string

[LouieLouieOhOh]

I am a beginner/novice using VB in excel. I am able to open an instance of IE (internet explorer) and input data from a spreadsheet into the web page (add cell values into text boxes in a form).

What I need to do is extract a text string from the page source ... the string is "always" preceeded by the text

<row id= '

then the string follows ... as

12345.67891.21212.65656

so, 5 digits, a period, etc. for a total of 23 charactors.

Can someone show me how to "grab" this string of data? example of the code is attached (can't give exact html document, sorry ... boss won't allow it).

 

[jamesjames1]

Hi,

Here is some useful excel script:
I had column 1 (strIPvalue) as the ip address and column 2 (strtest) as another data field. The script loops through so with the variables created you can do what you like.


Do While Not IsEmpty(objExcel.Cells(loopCount, 1).Value)
strIPvalue = objExcel.Cells(intLoopCount,1).Value
strtest = objExcel.Cells(intLoopCount,2).Value

'Displays the IP Address in a message box
Wscript.Echo strIPvalue
Wscript.Echo strtest

I'd suggest Regular Expression to find the data you need, there pretty powerful.

http://msdn2.microsoft.com/en-us/library/ms974570.aspx

Hope his helps..

 

[ClulessChris]

take a look at instr, Left, Right, and Mid functions

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[ClulessChris]

A bit more advanced but far more powerful are Regular Expresions' and example can be found in thread329-1450029

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[LouieLouieOhOh]

Thanks Gang!!!

instr, Left, Right did it!