標題:
[發問]
如何顯示網站的時鐘時間
[打印本頁]
作者:
donod
時間:
2013-9-10 12:50
標題:
如何顯示網站的時鐘時間
有些網站沒有顯示網站的時鐘時間,請教如何利用VBA,顯示出以下網站的時鐘時間,謝謝!
http://www.mobile01.com/hottopics.php?id=4
作者:
jakcy1234
時間:
2013-9-10 15:17
Sub get_time()
Set XmlHttp = CreateObject("Microsoft.XMLHTTP")
XmlHttp.Open "Get", "http://tw.yahoo.com/", False
XmlHttp.send
datetxt = XmlHttp.getResponseHeader("Date")
Set XmlHttp = Nothing
temdate = Split(datetxt, ",")
tempvar = Replace(temdate(1), "GMT", "")
temptim = Split(tempvar, " ")
Select Case temptim(2)
Case "Jan":
mon = "01"
Case "Feb":
mon = "02"
Case "Mar":
mon = "03"
Case "Apr":
mon = "04"
Case "Mar":
mon = "05"
Case "Jun":
mon = "06"
Case "Jul":
mon = "07"
Case "Aug":
mon = "08"
Case "Sep":
mon = "09"
Case "Oct":
mon = "10"
Case "Nov":
mon = "11"
Case "Dec":
mon = "12"
End Select
'//將獲取到的時間轉換為台北時間+8小時
timeGMT = temptim(3) & "年" & mon & "月" & temptim(1) & "日 " & temptim(4)
'timeGMT = CDate(temptim(3) & "年" & mon & "月" & temptim(1) & "日" & temptim(4))
GetNetTime = DateAdd("h", 8, timeGMT)
Cells(1, 1) = GetNetTime
Cells(2, 1) = Now()
End Sub
複製代碼
回復
1#
donod
轉自google search ---- Excel-VBA學習-網路時間取得
作者:
donod
時間:
2013-9-10 15:41
回復
2#
jakcy1234
十分感謝大大幫助!
歡迎光臨 麻辣家族討論版版 (http://forum.twbts.com/)