Delete Workbooks

L

Little Penny

I'm Looking for a macro that will delete all workbooks in folder
c:\temp that have not been modified for 7 day or more.


Thanks



Little Penny
 
B

Bob Bridges

You'll probably have to write one, Little Penny. Do you absolutely want to
be in Excel when you do it? because it seems to me that if you're not already
in Excel when you want to run this task, it'd be more convenient to write it
in VBScript; that allows you simply to double-click on an icon out in
Windows, instead of having to open a workbook in Excel first.

If, as seems likely, you're not sure how to go about writing (either in
VBA/Excel or in VBScript) code that will do that, some folks here won't mind
taking you on as a beginner and getting you up to speed. But are you willing
to learn how? If you're hoping just to have someone write it for you,
someone probably will, but how then will you know how to run it, and how to
modify it later when you need to do something different with it?
 
L

Little Penny

Thanks for the feedback. I forgot to post the code I was using. Also
I'm always willing to learn.


Have a great day...
 
B

Bob Bridges

I'm not sure where you choose to go from here, Little Penny. If you want to
write it in VBS, you can either contact me off-line (my email address is in
my profile) or go to the VBS forum to ask the same question - that's
microsoft.public.scripting.vbscript. If you want to correct code you already
have, you'll have to post it, of course. If you want to write it from
scratch in VBA/Excel, you can continue the questions here or, if you have no
idea how to begin, contact me by email as above and I'll sort of coach you
through it.
 
Top