Windows 7 Forums Search
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows 7. The Windows 7 forum also covers news and updates and has an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7 - Excel temporary saves

 
12-13-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
12-13-2011   #2


Windows 7 x86 since December 2008
 
 


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 script.zip (232 Bytes, 7 views)
My System SpecsSystem Spec
Reply

 Excel temporary saves problems?



Thread Tools



Similar Threads for: Excel temporary saves
Thread Forum
Solved Snipping Tool Saves Performance & Maintenance
Nothing saves after reboots General Discussion
[PC] Fallout 3 won't run game saves! Gaming
Formatting Excel 2010, Excel 2003 Microsoft Office
Can't open 2003 Excel Files in Excel 2007? Microsoft Office


All times are GMT -5. The time now is 05:51 PM.



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
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30