Prompt for license id and password

HI ALL,

I do not know it is possible or not i have created one tool in excel. I need that after 6 months when any one opens this excel (tool) Prompt a user form type Renewal of license id and password . When user provide the id or password the excel file renewal for next six months more... and prompt every day that 2 months are remaning 15 days remaining for expire license ...


Thanks
hammeed

It's possible but easy to break. You'd need to store the renewal date somewhere, maybe a text file or in the registry, maybe even in the workbook itself.

However, Excel is not a secure environment and it's relatively easy to crack passwords. So, if your client is not technically oriented, you might have a chance.

Regards, TMS

The code listed below will create a text file with the date and time the workbook is first used. It uses MsgBoxes for demonstration purposes; you need to remove them and replace the second one with your checks and action code. That is, is the date more than six months ago and, if so, take some action.

Considerations ... you need to put the text file somewhere that the client isn't going to "trip over" it, as they could just delete it. And you need to protect your VBA Project so that it isn't obvious what is happening.

Change the TxtFile location and file name to whatever you want/need.

It's far from foolproof but it will give a little extra protection.

Regards, TMS

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.