|
这个工具之前一直能用,但是最近却总是报错,代码还是原来的,不知道为什么?就是这个模块总报错,求大神指点!! 跪谢!!
Sub HTMLNavigation()
'Open site if it requires a PassWord Model!
'before running this, you need to insert and "microsoft.WebBrowser"to your excel.the method is to use this webbrowser to open the site first so that the cookies will be saved so as to make data-refresh possible.
'Call CreateHTML
Dim IE As Object
Set IE = Sheet1.WebBrowser1
IE.Visible = True
'Go to this Web Page!
IE.Navigate ThisWorkbook.Path & "\Map plotter.html"
'Check for good connection to web page loop!
Do
If IE.ReadyState = 4 Then '4="READYSTATE_COMPLETE"
'IE.Visible = False
Exit Do
Else
DoEvents
End If
Loop
Application.StatusBar = "Refreshing the map, please wait..."
'Wait for window to open!
Application.Wait (Now + TimeValue("0:00:03"))
Application.StatusBar = False
IE.Visible = True
End Sub
|
|