TranslationEditor

This repository contains the VBA code for the XLSM VVVVVV translation editor. The full versions of the XLSM can be found under Releases.

The .bas files are in the repo itself both for interest, and to provide diffs/comparisons between different versions, but they're not that useful by themselves unless you recreate the worksheets (it's a "Controls" sheet with buttons and a few cells with a special purpose, and then a separate sheet named after each .xml file in a language pack). All I did to get the VBA out of the Excel file was export each module from Excel itself (Ctrl+E).

Changelog

2024-01-06

• Add support for translation2 in numbers.xml

2023-10-08

• Replace Scripting.FileSystemObject (FSO) by ADODB.Stream to fix file encodings getting messed up on some systems, likely Japanese ones in particular (thanks KabanFriends!)
• Don't convert … to ... for CJK languages (the sanitization is done because Excel unwantedly converts three dots to a single ellipsis character, but Chinese and Japanese actually intentionally use it)
• Clarify error message if XML reading is unsuccessful (now gives the actual error instead of always "file not found", which may not be true)

2023-03-25

• Accommodate buttons field in cutscenes.xml
• Made the buttons on the Controls sheet bigger (for some reason they become tiny for other people, which is probably a DPI thing, so hopefully I've now compensated enough that the tinier buttons will all be readable)

2023-01-23

• Accommodate max_local fields (different max for CJK fonts)

2022-11-30

• Remove support for "Lots" in numbers.xml (it's removed from VVVVVV)
• Accommodate case field in strings.xml (for equivalent English strings needing different translations)
• Workaround a painful MSXML bug where XML attributes starting with ' have that apostrophe removed (just see the comments in export.get_file_xml)

2022-05-14

• Accommodate var field in strings_plural.xml
• Update description for numbers.xml to be more in line with VFormat changes and for potential removal of "Lots"

2022-02-07

• Accommodate expect field in strings_plural.xml

2022-01-22

• Initial version