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