All,

I have a web query routine written in VBA that I have been using for 2
years. All of a sudden, the query stopped working this weekend. I
started getting "Invalid Web Query" error. I haved tracked the
problem down to Temporary Internet Files. If I get an error, I simply
pull up IE and clear the files. All will be well for about 40 or so
queries. Does anyone out there know of a method to clear temporary
internet files in vba. I am looking for a way to clean out the cache
after every query. I have experienced this problem on multiple
machines using Excel 2003 & 2007 with IE7. All responses are greatly
appreciated.

Thanks!
Newt

Newt,
Try this:
http://vbnet.mvps.org/code/internet/deleteurlcache.htm

NickHK

"Newt" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> All,
>
> I have a web query routine written in VBA that I have been using for 2
> years. All of a sudden, the query stopped working this weekend. I
> started getting "Invalid Web Query" error. I haved tracked the
> problem down to Temporary Internet Files. If I get an error, I simply
> pull up IE and clear the files. All will be well for about 40 or so
> queries. Does anyone out there know of a method to clear temporary
> internet files in vba. I am looking for a way to clean out the cache
> after every query. I have experienced this problem on multiple
> machines using Excel 2003 & 2007 with IE7. All responses are greatly
> appreciated.
>
> Thanks!
> Newt
>

I have also started having this problem - and I've seen a single
reference to a similar problem at

http://malaysia.answers.yahoo.com/qu...4164814AAe96fr

Has anybody seen this problem elsewhere?

Anybody reported it to Microsoft? I strongly suspect a recent
automatic update around the middle of february 2007.

Peter



On Mar 8, 2:21 am, "NickHK" <TungChe...@Invalid.com> wrote:
> Newt,
> Try this:http://vbnet.mvps.org/code/internet/deleteurlcache.htm
>
> NickHK
>
> "Newt" <aaronnuetz...@gmail.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > All,
>
> > I have a web query routine written in VBA that I have been using for 2
> > years. All of a sudden, the query stopped working this weekend. I
> > started getting "Invalid Web Query" error. I haved tracked the
> > problem down to Temporary Internet Files. If I get an error, I simply
> > pull up IE and clear the files. All will be well for about 40 or so
> > queries. Does anyone out there know of a method to clear temporary
> > internet files in vba. I am looking for a way to clean out the cache
> > after every query. I have experienced this problem on multiple
> > machines using Excel 2003 & 2007 with IE7. All responses are greatly
> > appreciated.
>
> > Thanks!
> > Newt- Hide quoted text -
>
> - Show quoted text -