Translating Excel content from German to english

[sabascal]

Hi all,
I am trying to write a small macro to translate the content of an excel spreadsheet from german to english.

Having no idea of tools I could use, I was thinking about leveraging Google translator.
1) If cell content is text - take content and post it to google translate
2) Retrieve traduction and replace cell.

Please advise - If you know a good tool to do that - please advise

Thanks,
Sebastien.

 

[BiggerBrother]

You can do this with the webbrowser object. It allows you to call text boxes, and labels by name. These names are as they appear in the HTML source of the webpage, so finding the correct name is easy. All you need to do is to load the page in webbrowser. Wait until the whole pag eis loaded, which may take a moment, and then populate the page. The code then submits and returns a text box with the rough translation.

You might want to surk the net to find the best/most accurate translator, as I know only two well that some are really quite coarse thranslations.

BB