![]() |
|
#3
|
|||
|
|||
|
Quote:
Code:
Option Explicit
Function GetElementsByClassName1(cName As String, q As String)
Dim IE As New InternetExplorer
IE.Visible = True
IE.navigate "http://hk.dictionary.yahoo.com/dictionary?p=" & q
Dim html As HTMLDocument
Set html = IE.Document
Do Until IE.readyState = 4
Loop
Dim Result
Dim tag
Dim tags As Object
Set tags = html.getElementsByTagName("*")
Result = Array()
For Each tag In tags
If tag.className = cName Then
ReDim Preserve Result(UBound(Result) + 1)
Set Result(UBound(Result)) = tag
End If
Next tag
GetElementsByClassName1 = Result(0).getElementsByTagName("div")(0).innerText
IE.Quit
End Function
Could ya please debug the code for me? It seems that I cannot pass the arguments directly "strings" (with reference to the error help in Excel) It's beyond what I know about VBA. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to edit the "Format" and the "show level" of an EXISTING table of content? | Jamal NUMAN | Word | 2 | 08-14-2011 10:46 AM |
Word 2003 document suddenly "locked for editing" by me
|
lisa801 | Word | 3 | 07-08-2011 10:11 PM |
"Table of content" based on "Normal Style" behavior!!!!
|
Jamal NUMAN | Word | 4 | 07-08-2011 04:12 AM |
How to choose a "List" for certain "Heading" from "Modify" tool?
|
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
| "Microsoft Excel Application" missing in the "Component Services" on win08 | sword.fish | Excel | 0 | 02-26-2010 02:09 PM |