PDA

View Full Version : excel date activated self destruct



mazza
11-26-2009, 01:16 PM
i have an excel workbook (book1) which uses data on a second workbook(book2) to lookup data.
i want to place a date in a cell in book2 such that book1 checks the date on opening and terminates/self destructs if that date is older than today.
further more to prevent illegal copies of book1 being taken, i want book1 to also terminate/self destruct if it cant find the copy of linked Book2.
can anyone help please

lucas
11-26-2009, 01:49 PM
Lot's of people have tried this and I guess it can be done but only to a certain degree.

Anyone who really wants it can get it. Excel is not secure.

Search our Knowledgebase. There are several examples there that will give you ideas.

Again, if you want it to be secure then you should do it in .net or Visual basic.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=540

or

http://www.vbaexpress.com/kb/getarticle.php?kb_id=475