Hi, I know this can be done because I've seen it before. I have to login to a web-site and query some data. I have the code to get me to the web page but I have to login. I know there is a way to write into the macro to fill in the needed info and login.
Any assitance is greatly appreciated. What I believe to be the relevant source code for the login page is shown below. <div id="login"> <h3><a accesskey="l" name="login" href="#login"><span>eFlash</span></ a></h3> <form action="j_security_check" method="post" name="loginform"> <b>Type your ACE login ID and password that you use to log into your ACE workstation.</b> <div class="textinput"> <label for="username"> ACE Login ID:</label> <input tabindex="1" id="username" name="j_username" type="text"/> </div> <div class="textinput"> <label for="password">ACE Password:</label> <input tabindex="2" id="password" name="j_password" type="password"/> </div> <p class="case_sensitive_note">Note: Password is case-sensitive</p> <div id="logon_button_div"> <input tabindex="3" type="submit" value="Log On" alt="Log On Button"/ > </div> -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel