Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
need to upload copied excel files to admin page on website | Excel Discussion (Misc queries) | |||
Values from website turned into useable number values | Excel Worksheet Functions | |||
Need help creating a database for a shopping cart website. | New Users to Excel | |||
Can't open XL file on website in IE6 | Excel Discussion (Misc queries) |