VBA (Visual Basic for Applications)


The RC-WinTrans localization environment comes integrated with Microsoft Visual Basic for Applications™ (VBA).  VBA is a complete development environment with editor and programming code debugger for developing and running VBA macros.  Macros can be used to combine the powerful RC-WinTrans object model with a wide range of existing COM

components to create new, custom solutions to support and improve your software localization enterprise.


RC-WinTrans is already equipped with several VBA macros.  These are primarily macros with specific functionalities that also have an open code so that they may be customized if desired.  Examples of these include macros for word counts, check functions, reports, and command line support for RC-WinTrans that can be extended with one’s own customized commands to give the command line support maximum flexibility.


Customized VBA macros can be created with the VBA Editor that is provided and the event handler can be used to catch events fired by RC-WinTrans so that these macros can be included in RC-WinTrans’ activities and processes.  Some resources for creating/using VBA macros are included with RC-WinTrans, such as the RC-WinTrans Developer Help and the VBA Help.



Usage (Examples of Functionality Implemented with VBA Macros)

VBA macros can be used to implement virtually any modification/extension to the RC-WinTrans application.  Examples of functionality which has already been realized with VBA macros include:



Microsoft Excel Import/Export

Extends the original import and export functions from/to an Excel spreadsheet with (1) quicker, simpler application of both operations; (2) additional options to better control their results; and (3) VBA functions allowing the processes to be automated.


Google™ Machine Translation

Accesses machine translations generated by the Google Translation Web interface to quickly and easily supply translations while working with RC-WinTrans.


Multiline Editor

Allows texts containing new line and tab control characters to be displayed and edited in RC-WinTrans.


Maximum String Length Check While Editing

An add-on that alerts the user when the maximum string length for the selected text item has been exceeded while the text is being edited.  A "Length Check" window shows whether the currently selected translation unit meets or exceeds the maximum string length specifications.


File Converters

File converters are used to enable the translation of file types not already supported by RC-WinTrans.  File converters can be supplied to RC-WinTrans as VBA macros to read and to write a certain file to be translated.  (See also: "File Converters: Overview" in the RC-WinTrans Help.)