+ Reply to Thread
Results 1 to 5 of 5

Set a Trial Period For Use of Your Project

  1. #1
    Registered User
    Join Date
    02-28-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Cool 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:

    Please Login or Register  to view this content.
    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?
    Last edited by arlu1201; 03-27-2013 at 01:51 PM.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,029

    Re: Set a Trial Period For Use of Your Project

    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

  3. #3
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,160

    Re: Set a Trial Period For Use of Your Project

    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]

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,656

    Re: Set a Trial Period For Use of Your Project

    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

  5. #5
    Registered User
    Join Date
    02-28-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Set a Trial Period For Use of Your Project

    Can u please help me to write the macro for the same?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1