以下这段代码可以通过VBA打开web页,但如何通过VBA点击页内相应按钮并复制粘贴其数据呢?望高手指点啊
Sub OpenWebpageAndLogin()
Dim objIE As Object
'On Error GoTo error_handler
Set objIE = CreateObject("InternetExplorer.Application")
With objIE
.Navigate "http://172.19.2.12:8080/"
Do While .Busy: DoEvents: Loop
Do While .ReadyState <> 4: DoEvents: Loop
.Visible = True
With .Document.forms(0)
.UserName.Value = "yourname"
.passwrd.Value = "yourpassword"
.Submit
End With
.Visible = True
End With
Set objIE = Nothing
Exit Sub
error_handler:
MsgBox ("Unexpected Error, I'm quitting.")
objIE.Quit
Set objIE = Nothing End Sub |