Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jackblack1
 
Posts: n/a
Default Logging into a website


I have some code below that logs in to a website, I need to figure out
how to create a popup box that I manully enter in the password, (the
password changes ever minute).

Next, once I log in I have a tab that must be clicked on called
Reporting(it is the second tab) How do I write the code so that the tab
is selected and submitted.


Sub test()
Set ie = CreateObject("InternetExplorer.application")
ie.Visible = True
ie.navigate ("https://webid.gs.com/V4/login.cgi)
Do
If ie.readyState = 4 Then
ie.Visible = True
Exit Do
Else
DoEvents
End If
Loop

ie.document.forms(0).all("Username").Value = "example"
ie.document.forms(0).all("Password").Value = "example"
ie.document.forms(0).submit

End Sub


thanks

Jim


--
Jackblack1
------------------------------------------------------------------------
Jackblack1's Profile: http://www.excelforum.com/member.php...o&userid=34975
View this thread: http://www.excelforum.com/showthread...hreadid=547150

Reply
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
pasting data from a website changes text to date stebro Excel Discussion (Misc queries) 8 August 12th 06 08:39 PM
need to upload copied excel files to admin page on website hank business market Excel Discussion (Misc queries) 1 May 22nd 06 01:42 AM
Values from website turned into useable number values Erik Todd Excel Worksheet Functions 3 April 28th 06 11:51 PM
Need help creating a database for a shopping cart website. diane747 New Users to Excel 1 January 29th 06 05:26 PM
Can't open XL file on website in IE6 edger Excel Discussion (Misc queries) 0 December 20th 04 09:59 PM


All times are GMT +1. The time now is 01:54 AM.

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

About Us

"It's about Microsoft Excel"