Hi Group,

I have posed this in IE too. I am doing multiple VBA queries, over 70. A
failure happens part way into the Queries and since it is Sunday and the data
I am querying is static, it is hapening at the same point. Somewhere around
30 queries into the process it errors out.

What i found was that if I clean out part of the Temporary Internet files,
it will resume normal operation, so I think it is part of IE7, not Caching or
cleaning the Cache at some point. Anyone else run into this problem and did
you find a programming solution?

Thank you for your time and efforts.

David

David,
I sent you answers on how to do this and even sent you a file showing you
how to do it.
????????????

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"David" wrote in message
...
Hi Group,

I have posed this in IE too. I am doing multiple VBA queries, over 70. A
failure happens part way into the Queries and since it is Sunday and the
data
I am querying is static, it is hapening at the same point. Somewhere
around
30 queries into the process it errors out.

What i found was that if I clean out part of the Temporary Internet files,
it will resume normal operation, so I think it is part of IE7, not Caching
or
cleaning the Cache at some point. Anyone else run into this problem and
did
you find a programming solution?

Thank you for your time and efforts.

David

Hi Don,

Did not expect to see you on today. I wrote you something. I think it is an
IE thing and the 1024 limit, when I delete some of the Queries, it will
resume normal operation. I am not really certain that the 1024 is the
problem, but it did work after the deletion.

Any ideas would be helpful. Thanks.

David

"Don Guillett" wrote:

David,
I sent you answers on how to do this and even sent you a file showing you
how to do it.
????????????

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"David" wrote in message
...
Hi Group,

I have posed this in IE too. I am doing multiple VBA queries, over 70. A
failure happens part way into the Queries and since it is Sunday and the
data
I am querying is static, it is hapening at the same point. Somewhere
around
30 queries into the process it errors out.

What i found was that if I clean out part of the Temporary Internet files,
it will resume normal operation, so I think it is part of IE7, not Caching
or
cleaning the Cache at some point. Anyone else run into this problem and
did
you find a programming solution?

Thank you for your time and efforts.

David