Mobile menu

Calling a CAT Tool from EXCEL
Thread poster: JCFS
JCFS
Local time: 05:59
English to Portuguese
+ ...
Mar 14, 2006

Hi All,

I'm looking for a CAT Tool I can call from VBA in Excel.
I'd like to send it a text segment and have it return a 100% / Best Fuzzy mach pair (also nice-to-have would be to color the texts showing the differences like Trados/WordFast).
Does anybody know what Tools can be called from another program?

Thanks for your attention and help.

Rgds, JS


Direct link Reply with quote
 
xxxOlaf
Local time: 10:59
English to German
You can use the Trados API Mar 15, 2006

If you have Visual Basic or VBA skills you can call Trados Translator's Workbench from Excel. The following very simple macro opens the current or last TM, retrieves the value of A1 and writes the translation in A2, if it exists. (You'll need to add a reference to the Trados Translators Workbench (tw4win.exe) before you execute the macro.) For more information please refer to the Trados SDK.

'------ cut here ---------
Sub SearchFromExcel()

Dim Source, Target As String

Dim twb As TW4Win.Application
Dim tm As TranslationMemory
Dim tu As TranslationUnit

Set twb = GetObject(, "TW4Win.Application")
Set tm = twb.TranslationMemory

If Not (tm.IsOpen) Then
twb.OpenLastTM
End If

Source = Cells(1, 1) 'A1

tm.Search Source

Set tu = tm.TranslationUnit

If tm.HitCount 0 Then 'there's a not equal sign before 0
Cells(1, 2) = tu.Target 'A2
Cells(1, 3) = tu.Score & "%" 'A3
Else
Cells(1, 2) = "---"
Cells(1, 3) = 0 & "%" 'A3
End If

twb.Clear
End Sub


'------ cut here ---------
Note that somehow the BB removes angle brackets. There should be a smaller than sign followed by a larger than sign between tm.HitCount and 0.



[Edited at 2006-03-15 08:54]


Direct link Reply with quote
 
JCFS
Local time: 05:59
English to Portuguese
+ ...
TOPIC STARTER
TRADOS API Mar 15, 2006

Hi Olaf,

Thanks for your reply!!! This is down the line I was looking for.

However, I've been to TRADOS' (now SDLTrados) site and could not find the TRADOS SDK - do you know where/how to get this?

Again, thanks a lot. - JS

[Edited at 2006-03-15 16:36]

[Edited at 2006-03-15 16:37]


Direct link Reply with quote
 
xxxOlaf
Local time: 10:59
English to German
SDK is contained in the LSP version Mar 15, 2006

JCFS wrote:

However, I've been to TRADOS' (now SDLTrados) site and could not find the TRADOS SDK - do you know where/how to get this?



The SDK isn't installed by default, you'll have to select a custom install and then choose to install the SDK option. In Version 7.x this is one .chm file (in older versions it was divided in 3 .chms). You might need the LSP version of Trados for this.


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 »

Calling a CAT Tool from EXCEL

Advanced search


Translation news related to CAT tools





Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

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 »



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