I have this exact same problem. I can run the macro just fine 7 or 8 times and then it no longer imports the data from the site. Did you ever figure out how to correct the macro or in the alternative, get the macro to extract the data from the webpage after you manually logged in?
Thanks On Thursday, February 17, 2011 8:47:29 AM UTC-6, RCGUA 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? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
