De: Stratos Malasiotis <ieaaf@csv.warwick.ac.uk>
Objet: Re: Excel opening a cached web page & not refreshing
Date : vendredi 15 septembre 2000 11:38

Hi Tony,

Just pass the URL that you try to retrieve in the following function, just before you call your code

-------------------------------------
Option Explicit

Declare Function DeleteUrlCacheEntry _
            Lib         "wininet.dll" _
           ( _
             ByVal strUrl As String _
            ) _
             As Boolean


Public Function fncDeleteUrlCacheFile _
         ( _
           URL As String _
          ) _
           As Boolean
 'deletes a URL cache entry as it can be seen in Temporary Internet Files
  fncDeleteUrlCacheFiles = DeleteUrlCacheEntry(URL)
End Function
--------------------------------------

HTH
Stratos



Tony Miller wrote:
> 
> All
> 
> I have an app that checks prices off a web page frequently
> Often excel seems to be retrieving an old copy of the page from C drive
> somewhere.
> Despite having my internet settings correct for the temporary internet files
> and even deleting them, Excel still seems to find a local copy of the page at
> times
> 
> the code
> 
> webpage = "http:\\www......."
> 
> Workbooks.Open filename:=webpage
> 
>  ActiveWorkbook.SaveAs filename:=savedname
> 
> <<cut my data out>>>
> 
>   Workbooks(savedname).Close savechanges:=False
> 
>   Close
>      Kill (savedname)
> 
> Is there some command or call to force excel to go to the web site
> and not look for a local copy
> 
> I tried  Application.CommandBars("web").Controls(4).Execute 'refresh
> 
> but it doesnt help
> 
> Is the Open method a bad way to retrieve web data?
> 
> Many Thanks
> 
> Tony Miller