I have recently upgraded to Vista and Office 2007. I have an automated Excel
worksheet that collects a lot of data from the internet using web queries.
However, with Vista my temporary internet folder becomes full and the web
queries stop working. I can correct the problem by deleting those files in
IE (this is not a practical solution because my prior automated update
process needs continual live interface). Is anyone aware of a VB script that
might solve this problem - ie deleting temporary internet files?

I have tried this one but it doesnt work :

Sub Killfile()
Dim MyFile As String 'This line of code is optional
MyFile = "c:\Users\*user*\AppData\Local\Microsoft\Windows\T emporary Internet
Files\*.htm"
mypath = CurDir
Kill MyFile
End Sub