How to put an expiry date on an excel 2007 workbook

[johnGCUtaylor]

Hi guys,

I have been looking on various sites to find the correct code to put an expiry date on my workbook but it doesn't seem to be working.

Does anything have the correct code that will allow me to put an expiry date on my workbook so the workbook is deleted after a certain date?

Any info would be much appreciated.

Thanks

John

 

[hiker95]

johnGCUtaylor,

Welcome to the MrExcel board.

Be very careful with the below code links.

See:

Tom Urtis
MrExcel MVP
Deleteing a file in VBA
http://www.mrexcel.com/forum/showthread.php?t=48867

Yes you can delete an open file or ThisWorkbook active file, and here is how.
One friendly piece of advice, make sure you save a copy of your original workbook beforehand, in case you change your mind after the suicide code is executed.


Or:

http://www.vbaexpress.com/forum/showthread.php?t=3923