Recent content by pkrmott

First, let me say that I really appreciate the quick responses. I think this was one of those scenarios where I couldn't see the forest for the trees. About a month ago I had tried the method of using 1 webquery and simply changing the "Connection" property, but for some reason I got it into...

This topic has been covered extensively in other posts, but I have a peculiar problem that I cannot solve. On a spreadsheet, I create a webquery using a macro. Everytime I use the: "Set QT = ActiveSheet.QueryTables.Add(Connection:=totalline, Destination:=Range("A1"))" command, it takes 15-20...

Firefytr, thanks a million. I was able to use the code you directed me to and eventually traced my problem back to the fact that I had not included a "DoEvents" command where one was (apparently) necessary. Thanks again for the helpful post.

I would like a form to pop up and give a progress statement for a fairly long-winded macro I have written. Something along the lines of "33 of 10,000 complete" would be excellent, and I do not want to use the status bar (it's being used for something else already). At present, I have a form...

Thanks for the notes, it works great now.

Further searching seems to indicate that if I were to use an error handler and an associated goto command, the program never actually leaves the error handling stage. Thus, any future errors will not be handled appropriately (or, more exactly, AT ALL) by the error handler. How do you get...

I'm not familiar with the details of that code, although it does seem to work for me. I'm curious if I could just use a goto command and direct the user to re-input the web address. If I were to do so, would the error handler work a 2nd time if the use AGAIN entered the wrong address? A...

I have been using the querytable command within excel to access a user-defined website. If the user inputs an invalid web address, the macro I'm using fails on the querytables part. I have included the code below. Does anyone know of a method that will allow the macro to "check" to ensure...