Time bombing to delete workbook open

[iqballud]

Hi Guys,

I've been tried and got stuck how to create time bombing to delete workbook while opening if the workbook have been expired based on set date.
I took this code from "http://www.cpearson.com/" and just little bit modified.
This condition also already set:
1. Microsoft Visual Basic For Applications Extensibility 5.3.
2. Macro Settings and check the Trust access to the VBA project object model.

Below the code under module1.

Please Login or Register  to view this content.

And the message came when debug run "compile error: argument not optional", block on the "Kill.FullName".
My aim is to delete the workbook open if the date is expired.
Thanks in advance and appreciate for any helps.

Best Regards,
Iqbal

[Solus Rankin]

AFAIK you can't kill the open workbook you're running the macro from.

Additionally your kill line needs to be altered.

Have you tried running it from a personal.xlsb?

[shg]

In ThisWorkbook:

Please Login or Register  to view this content.

In a code module:

Please Login or Register  to view this content.

[iqballud]

shg,
Hihihihi...magic..the file it's gone...you are the man "shg"
Thank you sooooo much Bro.

Solus,
I will try later as your advice.

Again thank you so much.
Cheers

[iqballud]

Guys, the file will be deleted too though as attachment in mail?

[shg]

You're welcome.

[iqballud]

Forum Guru "shg",
I will ask the question: those codes will applicable to delete the file as attachment in email?
I tried but it could not be.

[shg]

I don't know what that means.

[iqballud]

I mean, if i write the code in the file then i send the file as attachment. While the receiver is opening the file, the file could not be opened due to gone directly. But the file itself will remain in the attachment. If i'd like to delete the file from the attachment too then i have to write another code to delete it from the attachment, is it?
Again thank you "shg" for your assistance.

[shg]

No, it will not delete it from an attachment.

[iqballud]

OK...Thank you sir.