Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop programe after trial use
how can i inhibt a programe to work for so long and stop working after
months trial, or the oposite to continue working if a specified key i use -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop programe after trial use
Dont know much about this but, if on the first worksheet (you will hav
to select it in the auto open) on a cell out of the way you ente =TODAY(), then format the cell by choosing number, custom and the enter ;;; the date will be hidden, then in the auto open you will nee something like If "A2"{enter date range here} The workbook.protect=True.....you would have to add your own VBA passwor and then protect the VBA from being viewd or changed. I see it like this....if you did something like the above the whol workbook would be locked after the certain date you could always put msgbox "Contact Vendor, Trial Period is Over" in the auto open if th date criteria is true. Hope this helps....sorry not really any good at writing code...mayb someone else can help you with the concept! Simon -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop programe after trial use
thank you for your response.
i had thought along the same lines but because the sheet is over written each time it is opened i.e. refreshed it would not work and is a possible non starter. having said that i will try it out tommorow with some data thrown in. --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop programe after trial use
You could psosibly in the auto open code add a counter for every tim
the workbook is opened and limit it this way say 2 months = 80 open then when COUNT=80 workbook.protect Or something like that, cos ur code is never refreshed! Simon Good luck -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop programe after trial use
You can search the archives:
using "expire workbook" as keywords, but the bottom line is that there's just about no way in XL to really prevent an even slightly ambitious user from bypassing any protection you put in. Worksheet protection is a joke, macro protection can be removed by commercial crackers, so any VBA you put in is vulnerable to anyone with the gumption to, say, read these newsgroups. You'll get better security if you make your application a compiled add-in, but even then you'll need to be careful that simply setting the machine's clock back, or deleting a hidden file, or changing/removing a registry setting, won't reset your app. In article , alexanderd wrote: how can i inhibt a programe to work for so long and stop working after 2 months trial, or the oposite to continue working if a specified key is used |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop programe after trial use
A similar question to trhis one was asked recently
It was suggested that the person have a look st http://www.andreavb.com/tip080006.htm -- Message posted from http://www.ExcelForum.com |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop programe after trial use
That will certainly work to keep newbies honest. Perhaps even the
moderately adept, IF it's in a compiled add-in. Bypassing VBA protection is trivial, so the code can't be in a regular VBA module. For instance, in a non-compiled app it would be easy to change only one value to give a ten year extension to the trial, e.g., bypass the VBA password and change If Not DateGood(30) Then to If Not DateGood(3660) Then The biggest problem with it when compiled is that deleting the register entries resets the trial period for another X days. In article , mudraker wrote: A similar question to trhis one was asked recently It was suggested that the person have a look st http://www.andreavb.com/tip080006.html --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office 2007 trial is very slow. Is this because it's a trial | Excel Discussion (Misc queries) | |||
Trial only | Excel Discussion (Misc queries) | |||
download trial version excel 2003? can only find trial version 200 | Excel Discussion (Misc queries) | |||
Trial Has Expired and I can't open spreadsheet created in trial - | Excel Worksheet Functions | |||
Trial Balance | Excel Discussion (Misc queries) |