Tool for translating macros in Excel document - suggestions needed 论题张贴者: ichibanmike
|
|---|
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]
| | | | | 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
Local time: 03:18
Japanese日语译成English英语
主题发起人 | 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
| | | | | 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]
| | |
|
|
|
| *.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
Local time: 03:18
Japanese日语译成English英语
主题发起人 | 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: You can also contact site staff by submitting a support request » Tool for translating macros in Excel document - suggestions needed | 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 » |
| | Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
Translation news related to CAT tools
