Compile workbook to EXE file
Before compilation you need to verify that environment of your computer meets the requirements of the DoneEx XCell Compiler.
To compile workbook to EXE you need to have the Microsoft Windows XP SP3 or higher and Microsoft Office 2003 SP3 or higher with the latest service pack and updates installed on your computer. Our product supports all 32-bit and 64-bit versions of Excel from 2003 and higher, including Excel from Office 365. Please make sure that Microsoft Office Visual Basic for Application (VBA) component is selected in your MS Office installation.
We assume that you already downloaded and installed the DoneEx XCell Compiler on your computer.
Excel compiler works with the copy of the workbook, so your original workbook will stay without altering.
Before workbook compilation you need to adjust your Excel to allow Excel Compiler to secure your workbook.
You need to enable “Trust access to the VBA project object model” MS Excel option via the following path:
Excel Options >> Trust center >> click button “Trust Center Settings…” >> Macro Settings >> enable check box “Trust access to the VBA project object model”
You need to perform this step once, before the first compilation.
How to compile workbook to EXE file
- Copy a workbook you would like to compile into My Documents folder or its sub-folder.
- Open the workbook by mouse double clicking on it in the Windows Explorer.
- The workbook will be opened in your Excel version. In our description we will use our Sample.xls file.
- Select DoneEx >> XCell Compiler >> Compile, from the Excel main menu bar.
- The following dialog form will appear.
- By default the ‘Application Name’ field is filled by the workbook name.
- Put the version number 1 0 2 as shown in the above image
- Enter the copyright text in the copyright box.
- Target path shows the location and file name of your compiled application. By default the location of the compiled EXE file will be in the same folder where your original workbook is located. The name of compiled EXE by default will be the same as your original workbook but with ‘.EXE’ file extension.
- Click the compile button in the XCell Compiler screen. Once the compilation completed, the following message will be displayed.
- Click OK on the compilation message screen.
- Click the close button on the XCell Compiler screen.
- Close Excel.
- Once the Excel worksheet is compiled, a file in the EXE format will be saved at the specified target path.
Browse “My Documents”. To use the compiled file, just double click the compiled file icon (sample.exe file).
- The file will be opened in Microsoft Excel environment .
- The file is secured now; you can send the compiled file to your client in a peace of mind.