Is Excel "caching" pages ?
Hello Tom, nice to hear from you again !
Have any idea of how to code it so as to delete the file in the cache ?
regards from Belgium,
Hervé+
"Tom Ogilvy" wrote:
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é+
|