language translation

i have an excel document that is created every week.
some times it is created in chinese (traditional) and then needs to be translated to english…
other times it is created in english and needs to be translated to chinese (traditional).

I was wondering if anyone knows of a script that can do the translation for me.

  • I would like to have 2 separate scripts, one for Chinese->English, and one for English->Chinese.
  • I dont mind if it needs to log on to internet and utilize babelfish or something similar.
  • I dont care if it translates each cell into a new document in the corresponding cell (i.e. Doc1 Sheet1 CellA1 translates to Doc2 Sheet1 CellA1)…or if it just replaces the cell in same document.

any suggestions?