This was posted by Tim Williams:

From: Tim Williams - view profile
Date: Sat, Feb 8 2003 10:11 pm
Email: "Tim Williams" <saxifrax@pacbell*dot*net>
Groups: microsoft.public.excel.programming


Have not tried it with an .xls file, but the following always works with web
content (.html etc)

file2 = "http://mysite/myfile.xls?blah=" & Format(Time, "hhmmss")
Workbooks.open filename:= file2


The dummy querystring forces a reload rather than a fetch from the cache,
since it's considered part of the URL. It's ignored by the webserver
however.


Tim.

====
I've never used it.

If you try it, please post back with your results.


affordsol wrote:
>
> 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é+

--

Dave Peterson