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 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/> *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
