Thread: Automate Excel Login When There Is No ID Field

Thanks for the help!

I want to automate filling in an input box in a Schwab Account. I would know how to do this if my input box had an id field, but it doesn't! Below is the source code for the box (the type and name are present):

<input type="Text" name="account_search_subaccount_name" size=16 value=""><BR><font size="-2">Last/Org Name</font></td>

Filling in this box with an excel macro should be as easy as setting up an excel macro to navigate to the page the input box is on and then using this partial code to fill it in:

.Document.forms(0).all("ID HERE").Value = "DATA FOR INPUT BOX"

This method is shown below to fill in input boxes to access a gmail account:

Sub IGoogle_AutoLogin() 
    Set ie = CreateObject("InternetExplorer.application") 
    ie.Visible = True 
    ie.navigate ("https://www.google.com/accounts/ServiceLogin?service=ig&passive=true&continue=http://www.google.com/ig%3Fhl%3Den&followup=http://www.google.com/ig%3Fhl%3Den&cd=US&hl=en&nui=1&ltmpl=default") 
    Do 
        If ie.readyState = 4 Then 
            ie.Visible = True 
            Exit Do 
        Else 
            DoEvents 
        End If 
    Loop 
     
     'USE VIEW SOURCE TO GET FORM ELEMENT IDS
    ie.Document.forms(0).all("Email").Value = "yourvalue here" 
    ie.Document.forms(0).all("Passwd").Value = "yourvaluehere" 
    ie.Document.forms(0).submit 
End Sub

From here - http://www.ozgrid.com/forum/showthread.php?t=80955

Could anyone please help me figure out a way to enter data into the said box through an excel macro? I tried entering the name field (i.e. account_search_subaccount_name) and that didn't work. Again I apparently have no id field for this box!?!

Thanks,
Joe