Make a Demo Verion 1

[DODO1]

Hi,

Does anybody know how I can make a Demo version of an excel application using visual basic? I was thinking of using a date or counting the number of times the programme is started.


thank you

DODO1

 

[combo]

You can use registry "VB and VBA Settings" key. There are GetSetting function and SaveSetting statement (plus GetAllSettings) to simplify access to that section of registry. For instance:

[tt]Counter=GetSetting(appname:="YourDemoApp", section:="StartUp", Key:="Counter", Default:=0)
Counter=Counter+1
' close application if counter>limit
SaveSetting appname:="YourDemoApp", section:="StartUp", Key:="Counter", setting:=Counter[/tt]

combo

 

[DODO1]

Thank You Combo

Just 1 thing, how do you reset the counter?

DODO1

 

[combo]

Just use the same way, somewhere:
[tt]SaveSetting appname:="YourDemoApp", section:="StartUp", Key:="Counter", setting:=0[/tt]
You can use other keys in your application, as ...Key:="Demo", setting:=True etc.
You can find some help in VBA help file.
BTW, it is not the best way to protect application (and excel is not the best platform for creating well secured application), but enough for standard user with blocked access to the registry.

combo

 

[DODO1]

Thanks Combo, you get a star from me.

DODO1