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

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?

--- "Little Penny" wrote:
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 for the feedback. I forgot to post the code I was using. Also
I'm always willing to learn.


Have a great day...











On Wed, 17 Sep 2008 22:11:00 -0700, Bob Bridges
wrote:

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?

--- "Little Penny" wrote:
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.

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.

--- "Little Penny" wrote:
Thanks for the feedback. I forgot to post the code I was using. Also
I'm always willing to learn.

--- On Wed, 17 Sep 2008 22:11:00 -0700, Bob Bridges wrote:
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?

--- "Little Penny" wrote:
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.

You can start here
http://www.rondebruin.nl/folder.htm

You can use the code in this macro in combination with the Kill command
Sub Copy_Files_Dates()

See also the examples for Kill on the same page


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Little Penny" wrote in message ...
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