Need help with Excel web query

[samq12345]

Here is what I found-the temporary file's folder for IE7 is a hidden folder and I cannot change the settings on that folder, thats the reason why the code won't work.

Is there a way around this?

[retsom]

Yeah, apparently the kill statement doesn't work on hidden files.

You could try this to unhide the folder:

Setattr "C:\Documents and Settings\.......\Local Settings\Temporary Internet Files", vbnormal

You have to replace the above path name with the specific folder in which your IE7 sames temporary files. The above command will make your Temporary Internet Files folder unhidden. You should then be able to use the kill command.