Is Excel "caching" pages ?

In addition to Tom's suggestion you might also try

'**************************
Sub ReadWeb()
dim r as string
dim fName as string

fName = "http://www.MYSITE.be/TestPHP/profsactual.xls"

r=cstr(rnd() * 1e6)
Workbooks.OpenText FileName:= fName & "?x=" & r

End Sub
'**************************

Addition of a random querystring to the URL should defeat caching.

--
Tim Williams
Palo Alto, CA


"affordsol" <affordsol@discussions.microsoft.com> wrote in message
news:AA1C1861-B14A-48B7-BD6B-2E3321035E4A@microsoft.com...
> 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" <affordsol@discussions.microsoft.com> wrote in message
> > news:81F3FCEF-5DF2-4E32-A72C-8770493244E7@microsoft.com...
> > > 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é+
> >
> >
> >

Thanks Dave - missed your post before adding yet another variant...

--
Tim Williams
Palo Alto, CA


"Tim Williams" <timjwilliams at gmail dot com> wrote in message
news:%23WUmIUmNGHA.2920@TK2MSFTNGP10.phx.gbl...
> In addition to Tom's suggestion you might also try
>
> '**************************
> Sub ReadWeb()
> dim r as string
> dim fName as string
>
> fName = "http://www.MYSITE.be/TestPHP/profsactual.xls"
>
> r=cstr(rnd() * 1e6)
> Workbooks.OpenText FileName:= fName & "?x=" & r
>
> End Sub
> '**************************
>
> Addition of a random querystring to the URL should defeat caching.
>
> --
> Tim Williams
> Palo Alto, CA
>
>
> "affordsol" <affordsol@discussions.microsoft.com> wrote in message
> news:AA1C1861-B14A-48B7-BD6B-2E3321035E4A@microsoft.com...
> > 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" <affordsol@discussions.microsoft.com> wrote in message
> > > news:81F3FCEF-5DF2-4E32-A72C-8770493244E7@microsoft.com...
> > > > 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é+
> > >
> > >
> > >
>
>