http://www.dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/
http://www.xlmacros.com/content/how-login-website-using-vba On Tue, Jun 14, 2011 at 8:41 PM, Don <donf...@gmail.com> wrote: > 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 > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> http://akoul.posterous.com/ *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- 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