View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default 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