Thanks so much. I'll give both of those a try. On Tue, Jun 14, 2011 at 8:07 PM, ashish koul <koul.ash...@gmail.com> wrote:
> > 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 > -- ---------------------------------------------------------------------------------- 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