Sub test()
Set ie = CreateObject("InternetExplorer.application")
ie.Visible = True
ie.Navigate ("soft-pak.com/customers/support2/User_Guide_v4.htm" & ActiveCell)
Do
If ie.ReadyState = 4 Then
ie.Visible = False
Exit Do
Else
DoEvents
End If
Loop
ie.Document.Forms(0).all("User").Value = "xxxxxx"
ie.Document.Forms(0).all("Password").Value = "xxxxxx"
ie.Document.Forms(0).submit
End Sub
________________________________________________________________________
Sub internetlogon()
With CreateObject("InternetExplorer.Application")
.Navigate "soft-pak.com/customers/support2/User_Guide_v4.htm"
Do until .ReadyState = 4
DoEvents
Loop
DoEvents
With .document
.items("username")="xxxxx"
.items("usernamesend").submit
End With
End With
End Sub
________________________________________________________________________
Sub internetlogon()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
'Go to this Web Page!
IE.Navigate "soft-pak.com/customers/support2/User_Guide_v4.htm"
'Check for good connection to web page loop!
Do
If IE.ReadyState = 4 Then
IE.Visible = False
Exit Do
Else
DoEvents
End If
Loop
'Wait for window to open!
Application.Wait (Now + TimeValue("0:00:01"))
IE.Visible = True
'Send logon information
SendKeys "xxxxxx", True
SendKeys "{TAB}", True
SendKeys "xxxxxx", True