in this case the only idea is the verification of QueryTable
Property:
BackgroundQuery = False

regards
r

Il mio ultimo lavoro ...
http://excelvba.altervista.org/blog/...ternative.html


"David" wrote:

Hi r,

Someone helped me me with the code and asked me not to share it. Sorry.
There is really not anything that complicated. It it bring in a csv table
from Yahoo and like I said the names are deleted.

The person that helped me I trust. I did look through the various class
modules to see if something might not be in them and found nothing.

I might copy the code out and put it in a new file to test it and see if
that makes a difference, but I expect not. Looking for others that might have
had similar problems and found some sort of solution.

What was most suprising was the continued Excel.exe memory usage, after the
macro has finished.

Still looking for insight.

Thanks,
David

"r" wrote:

you can show the code?
regards
r

Il mio ultimo lavoro ...
http://excelvba.altervista.org/blog/...ternative.html


"David" wrote:

Hi Group,

Hope all are having a good day. I have some code that does web queries. It
is sort of in 4 legs. It does a lookup of Fund ticker symbols and bring back
closes for a specific symbol and a specific single day. The list of symbols
is a little over 800.

It does this 4 times for 4 different dates, what I am calling legs. So 4
legs. Each leg about doubles the time of the previous leg. 2 minutes, 4
minutes, 5 minutes and 10 minutes. The query is deleted after each look up
and all names are also deleted.

When the macro is finished. Task manger indicated that Excel.exe is still
using 90% of memory. I am very perplexed at this situation.

Does anyone have any insights on this situation?
One of the other problems I am having is that when I leave this message and
check the box below "Notify me of replies", I do not recieve e-mail
notifications.

Thanks for your help,
David