View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Is Excel "caching" pages ?

Yes, I believe it is. (more precisely, the caching mechanism is being shared
by both applications). You will need to delete the file in the cache
before retrieving I would think.

--
Regards,
Tom Ogilvy

"affordsol" wrote in message
...
Hi everyone !

In my Excel application, I use the following code to get a table from my

web
site:
Sub ReadWeb()
Workbooks.OpenText

FileName:="http://www.MYSITE.be/TestPHP/profsactual.xls"
End Sub

To my greatest surprise, the output does NOT reflect the actual changes

done
to that file !

Is Excel using some "caching" as IE does ????



Thanks and regards from Belgium,
Hervé+