What do you get if you are using xlCompiler?
xlCompiler converts workbook (XLSM/XLSX/XLS) into stand-alone application which doesn't require Excel or
another application to run. Application created from workbook works like usual Document Oriented Applicaton.
You open it, change data and save changes in the external file. Later you can start application and open saved data.
Many products work in such way - all Office applications, Notepad, Image Editors, ...
The application can't be overwritten. This is normal behavior for all applications. So, changes are saved in the external file.
This is the only difference between workbook and application you are getting. Workbook can be saved, because it is a document
file for Excel or another Spreadsheet Application.
No programming required
You should not be a programmer to use xlCompiler. This product is as simple as possible.
You should only create spreadsheet in Excel or another Spreadsheet Application and fill
a few fields in the xlCompiler.
Everyone who uses Microsoft Excel is able to learn and use xlCompiler.
Hide VBA macros and Formulas
The user cannot get access to formulas and macros in the application files. xlCompiler doesn't provide any ability to view
internals of the book. Your user is working with Application, not with Excel Workbook.
xlCompiler gives you ability to create Application which is ready to distribution.
Formulas and VBA macros are stored in the compiled binary format. They are not accessible to users and there is no way to do
reverse ingeneering. You need to protect formulas and code, to deploy your solution to customers. xlCompiler is a
perfect and easy way to do it. There is no way to get original workbook from compiled application.
Options to activate your file on the customer's PC.
you can add to your workbook:
- End User License Agreement
- Activation Key Protection
Application could be signed with Code Signing Certificate. Why do you need this? Now Code Signing is an important feature.
If your application is not signed it will be blocked for download by browsers, anti-virus applications, etc. Code signing is possible
on with xlCompiler! Other applications create EXE which could be overwritten, in this case signature will be destroyed on the first
Macros are always enabled. If macros are disabled on your customer's PC - your workbook stops working and
shows warning message. Customer should enable macros manually. With xlCompiler you will never trap into
this situation - xlCompiler always executes Visual Basic macros.
Which spreadsheet features are supported?
Formulas, including array formulas and usual cell formulas. All the most common worksheet functions are supported by xlCompiler.
Functions and Forms created in the Visual Basic Editor. Below is a screenshot of the Form included into xlCompiler Samples:
And the same form in the compiled application:
Visual Basic for Applications is a powerful and highly important feature. xlCompiler compiles VB code in the workbook, so it
could be used in the compiled application in same way as in the source workbook.
Charts and Shapes. You can use charts and shapes (button, checkbox, combobox, connectors, list, ...) in the
Cell Styles and Conditional Formatting. xlCompiler supports same cell styles and Excel and allows to use conditional formatting. On the screenshot below
formulas has been formatted with gray by using conditional formatting rule.
Ribbon Interface. As you can see from screenshots, application created by xlCompiler has Ribbon interface.
Data Validation Rules. You can use Data Validation rules on the worksheets to validate entered data. Rule can have Input Prompt
and Message as in Excel.
Comments. Use comments to give more information to users in context of the current operation.
Tables. Filter your data and calculate Totals using Tables.
Zoom. Select appropriate zoom for your worksheets.
Printing and Print Preview. Select Print tab on the ribbon to preview and print your data.
In this list we've described only basic options. If you need to check if the specific feature is supported - please contact us.