Hello all,

I'm having a little trouble and could do with some help if possible!!

I'm trying to input a username and password from Excel using VBA into www.Masternaut.co.uk

I've written the following in VB but it fails miserably!


Private Sub CommandButton2_Click()
Dim EXP
Set EXP = CreateObject("InternetExplorer.application")
With EXP
.Visible = True
'put the webpage here
.Navigate ("http:\\www.Masternaut.co.uk")
Do While .busy: DoEvents: Loop
Do While .ReadyState <> 4: DoEvents: Loop
With .Document.myid("ctl00_loginBox.loginDetails")
.Login.Value = "login"
.Password.Value = "password"
.submit
End With
End With
End Sub

I cant seem to get the code to recognise the correct ID on the webpage, can anyone help please??

Thank you!!