Quote Originally Posted by sujittalukde
Thanks johnske, I tried that earlier also but that was also dependant on the system clock Can some modifications be done there to take teh time online. As I dont have depth knowledge of VBA I cant do that and thats why searching a help.
As I said - why bother? I would never reset my system clock just to extend the free use of someones program and i really can't see anyone else doing it either...

If you've given them (say) 30 days free use and then a notice that they've only got one days use left you're just inviting them to (maybe) reset the clock.

Once they've had their free use just cut them off without warning (after saving their previous data of course) and render the program useless so they can't resuscitate it, or just kill it (there's a link I've given there to show how to do that) - the method i've shown there leaves a hidden text file which prevents them downloading and re-installing a fresh version of your file.

You could also modify that to not only record the expiry date, but the date last used and a check to see if the current system time is earlier than the last-used time (i.e. if they've reset the clock)