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
skyla

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
Neutron16

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

 Excel temporary saves




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Win 7 Pro, 32 bit - Nothing saves to C:\Users\UserName\My Documents
I frequently use a program in my Win 7 Pro, 32 bit laptop that is supposed to save documents associated to it in the My Documents directory, located within C:\Users\UserName\My Documents, where that program's folder is located, but instead the documents are saved within the My Documents directory...
General Discussion
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.....
Gaming
Word document saves then disappears
I save a new document using either Save or Save as and it reacts as normal but then is not anywhere in Documents folders. The Find function does not locate it but it is still in the recently opened files section of Word. Thta is until 4 more files are opened. I tried saving changes to existing...
Microsoft Office
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)
Gaming


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:26.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App