A friend of mine has written a calculating programme that is based on Excel. A company is very interested in the programme and wishes to 'road test' a copy for a month. He wants to make sure that the programme vanishes after a month. Is there any way of terminating an Excel programme after a certain date?
I did think about making the text colour default to white, which would render it invisible on the white background, after 30 days or so but is this possible or are there any progs around that will do this?
There was a program called Softlocx 3.0 Express. Last seen on PCPlus CD 166A, quoted as coming from Bitarts via click here but their search engine comes up blank. I can't find any live links to it anywhere else.
Store a known starting value on a hidden, password-protected worksheet before making the workbook available. In the Workbook_Open handler, check this value: if it's the value you originally entered, replace it with the current date. In the future when the user opens the workbook, compare today to the stored date, and if it's been more than 30 days, put up a dialog asking for the registration number (or whatever scheme you had in mind). If not entered properly, close the workbook. Otherwise, replace the hidden value with something like the word "paid", and from then on no further action would be taken.
If you had mentioned Excel in the title I would have pounced on this several hours ago. They need to enter this in a module:
Dim nw As Date, x, y
nw = Date
x = DateValue(nw)
y = DateValue("01-feb-03")
If x > y Then Application.Quit
I am assuming that they already have some Visual Basic Code in the Workbook. If not, users can over-ride this by refusing to run macros when the pop-up security warning appears. It is easy to re-write a standard XL function in VBA so that the user has to enable macros for the Workbook to calculate correctly.