Calling a CAT Tool from EXCEL
Thread poster: JCFS
JCFS
Local time: 23:58
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: 04:58
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: 23:58
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: 04:58
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







Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



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