Tool for translating macros in Excel document - suggestions needed
Thread poster: ichibanmike

ichibanmike
Local time: 04:26
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]


Direct link Reply with quote
 

Sergei Leshchinsky  Identity Verified
Ukraine
Local time: 14:26
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..

Direct link Reply with quote
 

ichibanmike
Local time: 04:26
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


Direct link Reply with quote
 

Riccardo Schiaffino  Identity Verified
United States
Local time: 05:26
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]


Direct link Reply with quote
 

Piotr Bienkowski  Identity Verified
Poland
Local time: 13:26
Member (2005)
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


Direct link Reply with quote
 

ichibanmike
Local time: 04:26
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


Direct link Reply with quote
 


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


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

Tool for translating macros in Excel document - suggestions needed

Advanced search







Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
SDL Trados Studio 2017 only €415 / $495
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €415 / $495 / £325 / ¥60,000 You will also receive FREE access to our getting started eLearning program!

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search