How to Clickbuttons on internet Explorer pages with Excel VBA

[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

 

[Guest]

I'm not sure if Internet explorer supports Automation, maybe it does
But if it does then you'll need to know "its" object model in order to manipulate its controls

----- Bobsa wrote: ----

I can open a instance of Internet explorer with VBA in excel fine a
using some code I found here... navigate to my required webpage bu
then I need to click various buttons etc.... is the only way to d
this with sendkeys or can I refer to the various controls by name an
click them

I start it up with this code below

cheer

Bobs


====================

Dim IEObj As Objec

Sub Test(


OpenIE "https://ibol38.ibb.ubs.com/
End Su

Public Sub OpenIE(vURL As String

On Error GoTo ErrorHandle
IEObj.Visible = Tru
With IEOb
.Visible = Tru
.Navigate vUR
Do Until Not .Bus
DoEvent
Loo
End Wit
Exit Su
ErrorHandler
Set IEObj = Nothin
Set IEObj = CreateObject("InternetExplorer.Application"
Resume Nex
End Su