How to automate web login?
- From: "RB Smissaert" <bartsmissaert@xxxxxxxxxxxxxxxx>
- Date: Tue, 27 Sep 2005 19:19:52 +0100
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
.
- Prev by Date: Re: How To Get A Named Range To Grow
- Next by Date: Rotate a text box?
- Previous by thread: Re: How To Get A Named Range To Grow
- Next by thread: Rotate a text box?
- Index(es):
Relevant Pages
|
