View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Edgardo Sepulveda Edgardo Sepulveda is offline
external usenet poster
 
Posts: 1
Default 911 Excel Cache!

Hi, im having a problem with a little spider type application i made with
excel to import web pages, the scenario is the following:

My little excel spider, is supposed to get the same web page many times a
day, beacuse the content of this page, changes hour to hour, so this little
page, is created brand new daily, but in the course of the day, grows like a
log file, that's why i need the latest one, not the first one of the day

The problem is that i know know why, excel seems to work fine the firsts
hours, but suddently, keeps "bringing" the last one, not the real last page,
for instance, if i did this every hour, it works fine, until 2pm, and then
after 2pm, keeps bringing the 2pm page, even if the page did changed at 3
and 4 and so.

The questions are these:

Is there a page size cache trigger that fires when the page to load is
bigger than something? (not quite sure)
How can i flush excel cache programaticaly?
Am i doing something wrong in my code, putting it inside a vb.net timer
tick?
Im using Office XP to do this, and i've tryed also with Office 2003, any
clues why?

Here's my code

Dim xl As New Excel.Application()
xl.Workbooks.Open(http://www.mysite.com/mypage.html)

'mycode

xl.Workbooks(1).Close(savechanges:=False)
xl.Quit()
xl = Nothing
System.GC.Collect()

Thanks for your help

Edgardo