Query's keep updating when they dont need too!

[JimmyWilliams]

Hi Guys,

I have the following code, After running the macro, the query's want to keep updating. I want the query's to get the data once, and then stop updating afterwards (become static text). Does anyone have a method of making the query's static text?
I think the auto updating of querys is ok when there are only a few, however I have a list of about 500, and which results in going very slow and eventually an error message coming up asking if I would like the query's to stop running, when I accept half of the querys become an error strings.

(Column B has a list of website addresses.)

Please Login or Register  to view this content.

[JimmyWilliams]

I have attached the workbook with vba of what I am trying to do.
I it seems to go very very slowly, and becomes very laggy; anyone know how to speed this up?

[JimmyWilliams]

*Bumping Thread to get responses*

[JimmyWilliams]

*Bumping Thread to get responses*

[JimmyWilliams]

*Bumping*
I really don't know what I can do to improve my code. I need a way to change the query's into static text (I believe that it's probably the query refreshing each time the macro is looped through that is causing it to slow down around 50 querys.

[Eastw00d]

I have not much experience in this matter, but can you use this option?

Please Login or Register  to view this content.

B/R
Erwin

[Eastw00d]

For me this worked, but I have to admit, I deleted the rows below 150, because it takes about 45 seconds to complete to row 150, just for getting the data from internet, for only 10 rows.....
With the first macro I turned background updating of the other cells off, I did this before executing the main procedure.
Of course you have to update once in a while.....

Please Login or Register  to view this content.

B/R
Erwin

[JimmyWilliams]

Hi Eastw00d,

I've ran the "Sub Stop_Updating()" followed by your version of "Sub importwiseowlcourses()", however I am still getting the same problem.

The "Sub Stop_Updating()"
Doesn't do anything. (it's not called/used by the "Sub importwiseowlcourses()" and running "Sub Stop_Updating()" before running "Sub importwiseowlcourses()" doesnt add any extra value either.
Not being rude, just factual. Thanks for trying.

When I use your editted "Sub importwiseowlcourses()"
but I am still running into the same problem; that it takes forever to go through the list. I'm still looking for a way/method to speed this process up and believe that its due to querys being updated when they don't need to be.

[JimmyWilliams]

I am able to get the code to work for about 50 querys and then it slows down, I need to exit sub and then start again.
Does anyone have a method where I could make this code run for 100's or 1000's of querys?
Thanks