Excel temporary saves

skyla · 13 Dec 2011

I have this macro in my excel 2003. Basicly it downloads a certant information from a website ,then saves it and then calculates the difference between the last download.
Now the problem starts from here. I run it today, i does it thing, but when i run it tommorrow it somehow uses the the data which i downloaded yesterday, it like uses yesterday temporary file. But when i use some cleanup programs, and after that use my macro, it run like it supposed to be. How to make it so, that i don't have to use cleaner everyday? Sorry if it's really messy text

Neutron16 · 13 Dec 2011

For better understanding it would be nice to see that macro, but let's try something else first.

If this macro downloads something, at some point it is using IE temporary files folder or/and Windows temp folder.

I have created a script that deletes mentioned temp files.
You can:

1. Place clean_temp.bat in your Startup folder in the Start menu. It will be started everytime with computer.
2. Run clean_temp.bat manually AS ADMINISTRATOR everytime before Excel start executing that macro.
3. Create a task(s) in Task Scheduler to run that script at desired time(s).

Here is the file in archive: