B
Bobsa
I can open a instance of Internet explorer with VBA in excel fine an
using some code I found here... navigate to my required webpage but
then I need to click various buttons etc.... is the only way to do
this with sendkeys or can I refer to the various controls by name and
click them.
I start it up with this code below.
cheers
Bobsa
=====================
Dim IEObj As Object
Sub Test()
OpenIE "https://ibol38.ibb.ubs.com/"
End Sub
Public Sub OpenIE(vURL As String)
On Error GoTo ErrorHandler
IEObj.Visible = True
With IEObj
.Visible = True
.Navigate vURL
Do Until Not .Busy
DoEvents
Loop
End With
Exit Sub
ErrorHandler:
Set IEObj = Nothing
Set IEObj = CreateObject("InternetExplorer.Application")
Resume Next
End Sub
using some code I found here... navigate to my required webpage but
then I need to click various buttons etc.... is the only way to do
this with sendkeys or can I refer to the various controls by name and
click them.
I start it up with this code below.
cheers
Bobsa
=====================
Dim IEObj As Object
Sub Test()
OpenIE "https://ibol38.ibb.ubs.com/"
End Sub
Public Sub OpenIE(vURL As String)
On Error GoTo ErrorHandler
IEObj.Visible = True
With IEObj
.Visible = True
.Navigate vURL
Do Until Not .Busy
DoEvents
Loop
End With
Exit Sub
ErrorHandler:
Set IEObj = Nothing
Set IEObj = CreateObject("InternetExplorer.Application")
Resume Next
End Sub