musicgold
11-07-2010, 11:25 AM
Hi,
I am using the following VBA code to extract text from a webpage (http://www.frendz4m.com/p/forum/showthreads.php?forumID=13&subforumID=0&ID=2066722)
I am interested in the text inside a node called SPAN. As there are some unwanted SPAN nodes, I am trying to differentiate them on the basis of their font type, but I am getting an error at hinput.font = ”verdana” (run time error 438).
What property can I use to differentiate the SPAN nodes?
Set hdoc = IE.document
Set hColl = hdoc.getElementsByTagName("SPAN")
For Each hinput In hColl
If hinput.font = ”verdana” then
MsgBox hinput.innertext
Next
HTML source code
<span style='font:normal 12px verdana;color:#000000;'>Dad:Ess Baar exam me paas ho<br>ya fail BIKE zarur dilaunga.<br>Son: _
Kaunsi bike?<br>Dad: Pass he to “APACHE” college<br>jane ke liye.<br>Fail hue to “RAJDOOT” dood<br>bechne ke liye...</span>
Thanks,
MG.
I am using the following VBA code to extract text from a webpage (http://www.frendz4m.com/p/forum/showthreads.php?forumID=13&subforumID=0&ID=2066722)
I am interested in the text inside a node called SPAN. As there are some unwanted SPAN nodes, I am trying to differentiate them on the basis of their font type, but I am getting an error at hinput.font = ”verdana” (run time error 438).
What property can I use to differentiate the SPAN nodes?
Set hdoc = IE.document
Set hColl = hdoc.getElementsByTagName("SPAN")
For Each hinput In hColl
If hinput.font = ”verdana” then
MsgBox hinput.innertext
Next
HTML source code
<span style='font:normal 12px verdana;color:#000000;'>Dad:Ess Baar exam me paas ho<br>ya fail BIKE zarur dilaunga.<br>Son: _
Kaunsi bike?<br>Dad: Pass he to “APACHE” college<br>jane ke liye.<br>Fail hue to “RAJDOOT” dood<br>bechne ke liye...</span>
Thanks,
MG.