Technical forums » CAT Tools Technical Help »
Tool for translating macros in Excel document - suggestions needed
Thread poster: ichibanmike
ichibanmike
ichibanmike
Local time: 10:05
Japanese to English
May 8, 2009

Hi,

Does anyone know of a tool for translating macros in Excel 2003 files using SDL Trados? Or is there a way to do it using just SDL Trados 2007?

Thanks,

Mike


[Subject edited by staff or moderator 2009-05-08 20:20 GMT]
 
Sergei Leshchinsky
Sergei Leshchinsky  Identity Verified
Ukraine
Local time: 20:05
Member (2008)
English to Russian
+ ...
Are you sure... May 8, 2009

... you need to translate them? Macros are written in Visual Basic that does not need to be translated..
 
ichibanmike
ichibanmike
Local time: 10:05
Japanese to English
TOPIC STARTER
Strings need to be translated May 9, 2009

Hi Sergei,

It looks like the strings which are output to the screen for dialog boxes, etc., will need to be translated. (They are enclosed in double quotes " ".) I guess it is possible to just translate the whole *.bas file. I was just wondering if there were a better way.

Thanks,

Mike
 
Riccardo Schiaffino
Riccardo Schiaffino  Identity Verified
United States
Local time: 11:05
Member (2003)
English to Italian
+ ...
You don't need to translate the code, but what about the strings? May 9, 2009

Sergei Leshchinsky wrote:

... you need to translate them? Macros are written in Visual Basic that does not need to be translated..


The functional code probably does not need to be translated (but it might need to be localized, depending on what it is and what it does), but if VBA is used to display dialogs, etc., all the relevant strings would in fact need to be translated.

AFAIK, this would need to be done in the VBA editor, until the relevant strings could be exported by the programmer who created the application in some format that could be handled using a CAT tools

[Edited at 2009-05-09 01:13 GMT]
 
Piotr Bienkowski
Piotr Bienkowski  Identity Verified
Poland
Local time: 19:05
English to Polish
+ ...
*.BAS and *.FRM May 9, 2009

Riccardo Schiaffino wrote:

Sergei Leshchinsky wrote:

... you need to translate them? Macros are written in Visual Basic that does not need to be translated..


The functional code probably does not need to be translated (but it might need to be localized, depending on what it is and what it does), but if VBA is used to display dialogs, etc., all the relevant strings would in fact need to be translated.

AFAIK, this would need to be done in the VBA editor, until the relevant strings could be exported by the programmer who created the application in some format that could be handled using a CAT tools

[Edited at 2009-05-09 01:13 GMT]


You should be able to export the macros code to a *BAS file or files and if there are any dialogs involved, they should be exported to *.FRM files.

Then you could try the various programming language filters in SDLX to see how good they are at extracting translatable content.

Regards,

Piotr
 
ichibanmike
ichibanmike
Local time: 10:05
Japanese to English
TOPIC STARTER
Thanks for the info May 11, 2009

Thanks Riccardo and Piotr.

I'll talk to our software expert and see if she can figure anything out from this information.

Thanks,

Mike
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Natalie[Call to this topic]
Peter Zauner[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

Tool for translating macros in Excel document - suggestions needed







Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »