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