R
RB Smissaert
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
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