Recent content by jburgauer

I have taken the code above and added a new module to my workbook plus a click button that simply executes this code. I have had the need to execute it a few times, and lo and behold, it must do much the same thing as the force close code from CCLEANER does because after running this new code, I...

As I continue to study the problem (as the novice that I am) I have become more convinced that the issue is that IE does not play nicely and does not always release its "threads" (is that the right word?) as it should. Apparently other folks have found the same issues with internet explorer...

Further expirements suggest that I do not even need to close excel -- the CCleaner process to force Internet Explorer to shut down seems to be sufficient for me to restart the excel process without having to exit and re-enter excel. Another change that I instituted in my code, because I...

I have some more information that I have learned that might be helpful to resolving this problem. I mentioned before that I believe that this is caused by a resource that is being used and not properly released. By virtue of some experimentation I did, as I improved the code, I noted that...

Sorry --- I had to redcue the size and reattach

I would be happy to send you a file that you can run with actual live data in it. Please see the attached. On the page WORK HERE is a click button. This will start the process that will grab data from the work here page, initiate the web activity, drop the data into "your" extraction page...

I have installed your code in place of the prior code, and after about 45 web results (records) I got the same interrupt, The debugger shows that the code failed on this line: Set Browser = CreateObject("InternetExplorer.Application") ' Create a new browser object

OMG thank you. Please give me a bit of time to study and implement and I will reply.

Once again, your explanation is concise, well written, and easy to follow. That said, your comment "The full code is not always accessible to normal users and the code structures deviate from time to time. That means whatever code we put in here, is not going to be 100 percent reliable all the...

Rifat Hassan wrote a fantastic article which can be found about VBA about pulling data automatically from a website. His article can be read here...