Compile Excel workbook to EXE file
Before compilation your need to verify that environment of your computer meets the requirements of the DoneEx XCell Compiler.
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. 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.
Before workbook compilation you need to adjust your Excel to allow Excel Compiler to secure your workbook.
You need to enable 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 Excel Workbook
- Locate 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 >> Excel 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.