LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Login Userform Moh New Users to Excel 4 February 15th 12 10:39 AM
How to get system login name 39N 95W Excel Programming 2 July 15th 05 11:15 PM
Login Help!!! TMO[_6_] Excel Programming 1 February 8th 04 03:09 PM
Login Box help Bill Lunney Excel Programming 0 August 20th 03 11:45 AM
Login Box Tom Ogilvy Excel Programming 0 August 8th 03 01:42 PM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"