Home > Cook Books > Secure Data > Excel

UniKey Excel sample

Applied Products:
UniKey STD, UniKey Pro, UniKey Time
Programming Language:
Excel
Platform:

Windows 98SE, ME, 2000, XP, Server2003, Vista, 7, 8 et 10

 

You can protect XLS files with our Unikey solution by using two methods of protection. The first, describe hereafter, consist to apply a Unikey protection after you convert your XLS files to EXE files. So, you'll have to use a converting tool to convert XLS to EXE.


NOTE : The second method use the Unikey API by VBA calls inside your Excel files. This method is more flexible and you can find a VBA sample code inside the directory 'Samples' in the Unikey SDK.


On the market different tools are available. We advice you the use of XCELL compiler by the editor doneEx. You can find more details on the editor website http://www.doneex.com/

In the present Unikey sample you can try this converting tool by using the trial version that you can install with the file XCell.zip. The trial can be used for 30 days.

 


Dowload now XCell Compiler trial version


In the present Unikey sample you can try this converting tool by using the trial version that you can install with the file XCell.zip. The trial can be used for 30 days.


Please note you must be use an extern convert tools  


Picture-based Tutorial


1, Install the XCell Compiler software(Do a default installation for the test).




Step 2, Please accept the terms of Xcell compiler license and do a default installation.


Step 3, The installation is now finished.


Step 4, Open the sample file Sample.xls located in the directory XCell Compiler.


Step 5, Open in the Add-ons of Excel the menu doneEx and start Compile for generate an Exe file Sample.EXE.

Step 6, If you have modified the XLS files without register it, you can obtain the following warning message.


Step 7, you have not autorised the VBA execution, the following message appear.
In this case do:

7.a Open 'Excel Options'

7.b In ‘Excel Options’ choose ‘Trust Center’

7.c And ‘Macro settings’ and set ‘Trust access to VBA project object module’.

Step8, The Xcell compile windows appear. You can place your own informations. Indicate your settings and click on ‘Compile’.

Step9, The Exe is done!


Step 10,

The Sample.xls is now converted to a Sample.exe file. You can now protect it with our Unikey solution by using (Utilities/Envelopper).


Start Envelopper and select the file to protect.


Click on Execute button.

An EncryptedFile directory is created. It’s located in original EXE directory in which you can find the protected EXE file. This protected EXE file can be seen only for end user with a valid Unikey Dongle.

NOTE
To set the validity for Unikey dongles, please use the ‘Unikey setting’ parts in Envelopper software. Try it or consult the Manual to learn more about it.


Step 11, Launch Sample.exe file with a Unikey attached and just after try again without Unikey dongle attached.

In the case there is no unikey attached or no valid unikey, an error message appear and the Exe is not launched:



 


My Basket

Your basket is empty

  My Account

  Newsletter

Sign up now if you would like to recevied more informations about our products

Cancel my subscription