Deleting excel file on Occurrence of a particular date

[mangesh]

Hi all,

I need a feature which will delete an excel file on occurence of a particular date.

For example: If i would like to delete an excel file after 27th of july 2010, the moment i open excel file after 27th of july 2010 the file should get deleted.

[Andrew-R]

Windows won't let you delete a file which is open and you can't close the file to delete it, but have the delete macro continue to run, so you'd have to open a new workbook, pass control to a macro in that book and have it close and delete the calling workbook.

Alternatively you could save the original workbook under a different name and then delete the original, although, of course, that would still leave you with a copy of the workbook.

Or you could have a master workbook which parses through a directory structure, opens all of the workbooks it finds, checks to see if they should be deleted and then closes and deletes them.

If you're writing a macro which is going to delete things then be very, very sure to make a backup of pretty much everything, otherwise you're almost certainly going to lose data,

[mangesh]

Hi Andrew thanks.
I am ok even if all the sheets can be deleted.
Can you please help me with that?

[shg]

Please Login or Register  to view this content.

Of course, you have to force the user to enable macros, which is covered in many examples in the forum.

[mangesh]

Thanks Shg for your help