How to automate web login?
Trying to automate a web login (username and password) to a Yahoo group.
The purpose is to automate the download of a setup file.
I have tried with a reference to MS Internet controls in Excel and it is no
trouble to get to the website:
Dim IeApp As InternetExplorer
Dim sURL As String
'Create new instance of IE
Set IeApp = New InternetExplorer
'Make it visible - some things don't work
'unless it's visible
IeApp.Visible = True
'define the page to open
'sURL = "http://groups.yahoo.com/group/xxxxxx/"
'navigate to the page
IeApp.Navigate sURL
'Pause the macro using a loop until the
'page is fully loaded
Do
Loop Until IeApp.ReadyState = READYSTATE_COMPLETE
How though do I pass a username and password?
I understand that these can be given as part of the URL, but can't figure
out the right syntax for this.
Thanks for any advice.
RBS
|