Send me the generated code, let me try it. (replace the username and password with XXXXXXXXX).
Regards, Kishan Reddy, K On Feb 17, 10:39 pm, ashish koul <koul.ash...@gmail.com> wrote: > write > on error resume next > on the line above in the code which is giving errors see if that helps > > > > On Thu, Feb 17, 2011 at 8:17 PM, RCGUA <stv.nels...@gmail.com> wrote: > > With Microsoft Excel 2003, using the "Web Query" feature, I record a > > macro, put the URL of the website into the New Web Query and that > > opens a new instance of Internet Explorer. Using the Web Query, I go > > to a specific table within the tables on the web page and select the > > table that I want to get the data from and the Web Query copies the > > data and pastes it into Excel. The website that I am getting the data > > from requires a login and password. I wrote some VBA code to send the > > username and password and that works at first, however, if I use this > > web query several times in one day and after using the Web Query > > several times, I am logged into that website many times and I begin > > getting error messages and the Web Query does not grab any data. > > > Is it possible for the Web Query to to switch to the existing, already > > opened and logged into IE and grab that data and paste it into Excel, > > instead of opening a new browser window every time the query is run? > > > Or, if that is not possible, is it possible, to run the macro that > > uses the login and password, but then, after copying the data, have > > the query automatically logout and close the new instance of IE? > > > -- > > > ---------------------------------------------------------------------------------- > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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/> > *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
