XCell Compiler

  • Product
    • Home
    • News
    • Options Overview
    • Features By Licenses
    • Excel Formula Protection
    • Workbook Copy Protection
    • VBA Copy Protection
    • Custom Message Content
    • Bulk Registration Key Generator
  • Q&A
    • Install and Uninstall
    • Questions about trial version
    • Technical
    • Troubleshooting
    • Buying product
    • Updates
  • How-To
    • How to compile workbook to exe
    • Create registration key for compiled workbook
    • Create protected trial/demo workbook
    • Compile EXE for Excel 32 and 64 bit
    • Hide Excel on start
    • Keep compilaton options settings
    • Export/Import changed data
    • Set date limitation for workbook
    • Translate or change default messages
    • Runtime API References
    • Protect Workbook with Dongle
    • Compile Time Troubleshooting
  • Download
  • Order
  • Testimonials
  • Contact Us

How to modify or translate messages in compiled workbook

The custom resources dictionary allows you to modify or create custom runtime messages in the compiled workbook. You can also translate some of the default messages in the compiled workbook to another language.

The custom resources dictionary is a text file encoded in UTF-8. The compiled EXE file incorporates some of the text resources from the dictionary file to show messages.
As a matter of fact, you can create your own resources dictionaries for different languages.
To create a custom resources dictionary, you need to copy the ‘ENGLISH.dic’ file from the DoneEx XCell Compiler installation folder to any location where you are going to keep it and then rename the file.

Open this newly copied dictionary file in Microsoft NOTEPAD.

View of custom resources dictionary in Microsoft Notepad

 

Content of the dictionary file has a ini-file structure. Notice that each text resource is written as a key/value pair connected by the ‘=’ assignment sign on a single line: MNEMO_CODE_KEY=Text value.

In the image above, MNEMO_CODE_KEY is highlighted with red and the text value is highlighted with green.

You have to keep the MNEMO_CODE_KEY (left side, before the assignment ‘=’ sign) unchanged.

If you want to change a text value of a resource, then you need to rewrite the part to the right of the ‘=’ assignment sign with your content. Particularly, we recommend writing the text value in a single line. In other words, without starting a new line. Some of the text resources may appear in a multiple lines message box. To start a new line in the text you need to insert the ‘\n’ symbol combination. While displaying, ‘\n’ will change to a new line transfer.

 

Example of resource record structure for custom runtime messages:

MNEMO_CODE_KEY=Text value\nThis part of text will be shown on new line.

If you want to keep some text resource empty then you need to use “\r” text (without quotas) as the value of such resource.

Like:  MNEMO_CODE_KEY=\r

You can rewrite the text values for mnemo codes existing in default ENGLISH.dic file. If you add some other mnemo code and a text value for it then the message will ignore such text resources.
Make sure that your Custom resources dictionary files are in the UTF-8 encoding format. Ensure this by using the ‘Save As’  button in Notepad making sure that you have selected UTF-8 encoding.

Select UTF-8 encoding on SaveAs form of the Microsoft Notepad

 

 

To use the custom resources dictionary (for something like creating custom runtime messages) you need to click on the ‘Custom resources dictionary’ link on the compilation form and select the dictionary you want to use.

 

Select custom resource dictionary form that allows you to create custom runtime messages

 

Related Articles:

Template Tags

VBA Compiler Available

DoneEx Vba Compiler for Excel
  • XCell Compiler
    • News
    • Options Overview
    • Features by licenses
    • Excel Formulas Protection
    • Workbook Copy Protection
    • VBA code copy protection
    • Custom Message Content
    • Bulk RegKey Generator
    • Privacy Policy
  • How-To
    • Compile workbook to EXE
    • Use registration key tool
    • Create trial/demo workbook
    • Select target Excel bitness
    • Hide Excel on start
    • Options settings configuration
    • Export/import changed data
    • Date limitation options
    • Translate messages
    • Runtime API References
    • Protect Workbook with Dongle
    • Compile Time Troubleshooting
Copyright 2005-2024 © DoneEx LLC. All Rights Reserved.