How Creat Self Destruct Excel file

[ajaypal.sp]

Hi,


Can anyone please help me to create Self destruct file in excel based on time / (Ex: 10 minutes / 30 minutes)

Criteria: While any member opening the excel file , VBA code in the file should automatically run based on mentioned time in VBA Code and file automatically should be destructed.


Regards
SP.Ajay Pal

[mikerickson]

What do you mean "self-destruct"?
What is to prevent the user from copying the data from your book and putting it in another?

Excel is not a secure platform, its security is good against compliant thumb-fingered users, but not against malevolent users.

[ajaypal.sp]

HI

Thank you for reply.

What is the use of "kill" function in VBA and How to use? I think, with the use of "kill" function we can create self destruct program in excel.

Regards
SP.Ajay Pal

[Obsessed]

You would have to have the macro that kills in your personal workbook. The issue is, you can't call a macro to kill your workbook, if the code that would kill it is in said workbook. Alternatively, you could create a new instance of excel, and use that instance to kill the file. You could have a workbook saved on your computer that would simply perform the function of deleting the file. Then it's as simple as calling the macro in that workbook, and having the macro save and close (so you don't have prompts) the workbook you wish to kill.

[shg]

To kill the workbook 10 minutes after opening ...

In ThisWorkbook:

Please Login or Register  to view this content.

In a standard code module:

Please Login or Register  to view this content.

[mikerickson]

I'm wondering what the purpose of this is?

If you are killing a file to protect it from bad people, consider that the writer of the code had to ask about the technique on a public internet forum. That means that the bad people know more Excel and are more experienced than the designer of the security system.

If this is to protect data from bad people, it won't work. Bad people are good programmers, are very clever. Excel is not a secure platform.

If this is to create a "trial version" in a commercial setting, there are other ways to do that. (These ways can be defeated, but if your customers aren't honest, they'll find other ways to rip you off.)

[shg]

I agree with everything Mike said.