Bulk Registration Key Generation for protected Excel workbooks
When there is a need to generate and keep track of registration keys for one or more customers – you need to have a special tool which helps to do that in one click. We have created a tool especially for this case – the Bulk Registration Key Generator.
Bulk Registration Key Generator is a tool that allows you to generate multiple registration keys for your customers with one mouse click.
Since the ‘Copy protection with registration key’ feature is only available in Business PRO license of the product, you may only take advantage of the ‘Bulk Registration Key Generator’ on a computer with DoneEx XCell Compiler registered with a Business PRO license.
When you decide to use this utility, you need to download the ‘BulkRegKeyGen.xlsm’ and save it into your Documents folder. From this moment on you will use this saved workbook as your Bulk Registration Key Generator.
How to Use the ‘Bulk Registration Key Generator’ tool
Open the BulkRegKeyGen.xltm workbook from the location where you have saved it.
As you can see, the interface of this tool is straight forward and corresponds to the ‘Registration Key Tool’ dialog window available under the DoneEx Excel tab.
The field B1 and the fields under the columns A, E, and F are clickable. After a double left click with the mouse on those fields you will get a dialog window which allows you to select a target value of the field interactively.
The first thing you need to do is to set the path to your generated registration keys storage. To do that you need to double click on the cell to the right of “Path to RegKey Storage:” (the B1 cell) and select the folder in the opened “Browse” window. In subfolders of this folder you will find all generated registration keys when registration key generation is successfully finished.
Please notice that all generated registration keys will be saved in this path:
“Path to RegKey storage” >> folder with name of “Customer email” content>> folder with name of “Application Name” content >> zip-file with the customer computer id as its name, which contains the generated registration key. In most cases you will not need to search for the newly generated regkeys in Windows Explorer because after generation a hyperlink will appear under column ‘G’. This link will take you straight to the zip-file containing the generated registration key. Just click on that link to get to the file with the registration key.
Fill out customer’s data for registration key generation.
Now you need to enter the path to the EXE file that was compiled with the “Copy Protection” option for which the registration key is going to be generated. To do that you need to double click on a cell in the “A” column, on a row under the “Path to EXE” label, to set the path to the executable file.
In the same row, type in the Customer Name, Customer Email, and the Computer ID that the registration key is being generated for, in columns B, C, and D respectively.
If you want a time limit on the registration key, you can fill out the “Date From” and “Date To” sections. While this step is optional, both dates — “Date From” and “Date To”— must be filled out for this feature to function.
As mentioned before, the fields in columns E and F are double clickable. On a double click you will get calendar window to select the appropriate date.
If at this point the utility highlights any cell related to the registration keys you wish to create in orange or red, be sure to fix the issues in those cells before proceeding.
Once you are ready to create your registration keys, select the first row of information that you have put in with a single right-click on any cell in that row and ctrl + right-click on any other rows you wish to create registration keys for.
You can also single right-click on any cell in the first row you wish to create a registration key for and Shift key+Right-click on any cell in the last row you wish to create a registration key for. This way, the first, last, and any row in-between will be selected.
Now that you have selected all the rows that you wish to create registration keys for, click the “Generate RegKey” button.
You have now created a registration key for every row that you have selected in previous step! Just follow any of the newly generated hyperlinks that have appeared under column G in every row that you have generated a key for. These hyperlinks lead to the location of their respective registration key.
To open the folder with the ZIP file that contains the created registration key you need to click to the link in column ‘G’ of the appropriate row.