Set a Trial Period For Use of Your Project
To set trial period of use of the project , macro code given in the forum is as under:
But ,there is one problem in this macro code, when system date is set to the earlier date it starts working, I just want if it is for 7 days from now. It work for only 7 days when system date is reset then file should close automatically. Can anyone help me for this?
Please Login or Register to view this content.
Last edited by arlu1201; 03-27-2013 at 01:51 PM.
I think you will have trouble solving the problem unless you can protect the setting of time (which may be changed in the OS). You maybe should sum up the running time of the workbook and store and compare that with a given time. AFAIK using VBA alone canīt solve the issue.
Ciao,
Holger
Last edited by arlu1201; 03-27-2013 at 01:51 PM.
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
ras2021,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
You could instead record the system time each time the workbook starts on a veryhidden sheet. If it's earlier than the last time (with perhaps an hour leeway), then void the evaluation period immediately.
Entia non sunt multiplicanda sine necessitate
Can u please help me to write the macro for the same?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks