Hello,

I just joined this help forum and am hoping someone can solve a dilemma. I am looking for an Excel add-in that will make it easy to edit HTML content that is in select cells of a multi-sheet Excel spreadsheet.

First, some background information. I have a .NET data set that has been written to an XML data file. The XML describes 15 different tables, many rows and data. It is essentially an XML database. The XML file uses a standard database schema. This XML file will display a multi-page website in English. I am looking for a way to have the XML content translated into multiple languages.

I would like to use Excel to edit the XML file because any translator that I work with will have Excel on their computer. I have successfully tested the process of editing the XML file in Excel. Specifically, I open the .xml file and select option "Use the xml source task pane". I then drag each table into the A1 cell of a worksheet. Each table goes into its own separate worksheet. I back click on the map and select "xml refresh." I now can see and edit my XML code. When I am done, I save the modified spreadsheet to an xml data file.

The problem is that some of the XML tags (i.e., individual cells in the Excel worksheet) contain 500+ characters with quite a lot of HTML formatting. The translators that I will be working with to translate the text from English into Language X are not HTML programmers. They will no doubt corrupt the HTML code if they edit it directly. Since I do not speak these other languages, I cannot format their translated text after the fact. I need the final translated HTML code to have the same look and feel as the English version.

Does anyone know of an add-in that could help me with this? Ideally, I need an HTML editor that supports the extended character sets for European languages (German, French, Spanish, Italian are top priority). The editor will allow someone to import the English HTML code from Cell E2 (for instance) and then translate and format the cell contents into Spanish. Then the translator can save the translated HTML code into Cell F2 (immediately to the right of the English version).

Once I have the formatted and translated HTML code, I know how to export it from Excel to an XML data file.

Hopefully this makes sense. There must be something out there that I can use. Help!

Chip