- ©«¤l
- 361
- ¥DÃD
- 57
- ºëµØ
- 0
- ¿n¤À
- 426
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2003,2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2022-12-8
|
¦^´_ 1# PKKO
- Sub ex1()
- For i = 1 To 30
-
- Cells(i, 4) = Len(Cells(i, 3))
- Cells(i, 5) = InStr(Cells(i, 3), "(")
- Cells(i, 6) = InStr(Cells(i, 3), ")")
- Cells(i, 7) = Mid(Cells(i, 3), Cells(i, 5) + 2, Cells(i, 6) - Cells(i, 5) - 3) '¤½¥q¥N½X
- snum = Cells(i, 7)
- Set HTML = CreateObject("htmlfile")
-
- Dim strText As String
- With CreateObject("WinHttp.WinHttpRequest.5.1")
- .Open "get", "http://www.travel.org.tw/showtable.aspx?id=" & snum, False
- .Send
- strText = .responseText
-
- HTML.body.innerhtml = strText
- Set tb = HTML.all.tags("table")(0).Rows
-
- For x = 1 To 13
- Cells(i, x + 7) = tb(x).Cells(1).innertext
- Next
- End With
- Next
-
- Cells.EntireColumn.AutoFit
- End Sub
½Æ»s¥N½X
test.zip (27.6 KB)
|
|