Macro to free drive space before saving

[pedrofogao21]

Hi guys,

I was hoping one of you gents could help me with a small matter.

In my workplace, we use a network drive that is constantly full. A lot of times when I try to save an excel file I get the message saying that the drive is full, which is a pain. I created a folder in there where I keep some junk files (around 1Mb each) so I can move them to my personal drive to be able to save my file. After I save, I move back the files, so I will always have some space to free up.

I was wondering if there is a code that would move some files in this folder (around 10 files would propably do), and then return them to their original place, for whenever this error occurs, perhaps something similar to a Workbook Before Save...

Let's say the network drive is called "R:\Network\MyFolder" and the personal is "C:\Junk Files"

Many thanks!!!!

[TMS]

If they're junk files, there doesn't seem much point moving them backwards and forwards. You could just keep a copy of them on your local drive and delete them from the network drive when you need space there. After you've done whatever, copy them back.

Seems a bit of overkill to drive this from Excel. You might just as well have a couple of batch files for before and after save.

Regards, TMS

[pedrofogao21]

Yes, I could delete and copy them back, no problem.
It might be overkill....I don't know if the code would take longer to run that the time it takes to do it manually..

I only ask because I have to do this several times every day, so if there was something simple to run it could be better to have Excel do it...

Thanks again

[JosephP]

is getting more disks an option? they're pretty cheap these days and I doubt your excel issue is the only problem you have if your network is full! ;-)

[TMS]

You could use Notepad to create a couple of DOS batch files. Intheory, you could run them from Excel but I don't think it's worth it.

CopyFiles.bat

DelFiles.bat

You will not be asked for confirmation or see any display on the Cmd window. You can run them from Windows Explorer by double clicking on them or you could put shortcuts on your desktop.


Regards, TMS

[pedrofogao21]

OK, thanks for your help TMS

[TMS]

You're welcome. Thanks for the rep.


Please mark your thread as solved.