Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Excel temporary saves

13 Dec 2011   #1

Windows 7 Ultimate x64
Excel temporary saves

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

My System SpecsSystem Spec
13 Dec 2011   #2

Windows 8.1 ; Windows 7 x86 (Dec2008-Jan2013)

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:

Attached Files
File Type: zip (232 Bytes, 17 views)
My System SpecsSystem Spec

 Excel temporary saves

Thread Tools

Similar help and support threads
Thread Forum
Browser that saves battery power
i am in need of a suggestion, i would like to know which internet browser thats saves power when you are using the battery so far i found out IE10 doesn't, Google Chrome does, but i am concerned about my privacy and Mozilla Firefox doesn't, so any other suggestions would be helpful thank you
Browsers & Mail
Skyrim saves corrupt help!
so i was having problems with my skyrim game stuttering hella lot in game, so i decided to uninstall it. when i reinstalled it, then went to go play it, when i load from a save, it crashes to desktop. how can i fix this? or do i have to redo all my progress.....
Snipping Tool Saves
After completing a backup image recovery to a different hard drive than before, it seems that most everything is in order, except that I'm no longer able to save a snip with the Snipping Tool. If I select the save icon on the toolbar, or save from the file menu, nothing happens. I just ran...
Performance & Maintenance
Nothing saves after reboots
Hello, I have a little problem with my laptop here, I am using Windows 7 enterprise 64-bit and everytime I reboot, nothing saves at all. This is quite annoying since I downloaded a 14GB game and it just vanished after reboot, now I got to download it again. I know there is a way to disable this...
General Discussion
[PC] Fallout 3 won't run game saves!
I am trying to play my fallout 3 on my PC and whenever I try to load a new game or continue a game, as well as load, it will load for a little bit then crash. (My PC Specs are below and this was left out, my hard disk memory is 500GB)

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 09:08.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App