Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Login Userform | New Users to Excel | |||
How to get system login name | Excel Programming | |||
Login Help!!! | Excel Programming | |||
Login Box help | Excel Programming | |||
Login Box | Excel Programming |