Export mdb file from termstar nxt? Thread poster: Wilmer Brouwer
|
Does anyone know if it is possible to export an MDB file from termstar nxt to Excel or any other file format that can be used in other software? I tried the obvious option to go to dictionaries > export terminology > excel but as with most functions in Transit this does not seem to do what I would expect. Nothing seems to happen when I try that option. I would really appreciate any help.
[Edited at 2010-07-20 15:04 GMT] | | | export to martif | Jul 20, 2010 |
which is more or less straightforward, and then use my macro for converting martif to xls below - the resulting xls is in unicode, by the way. Sub mtf2xls() Dim fs, a, strs, rets, langs(10) Flag = 0 strs = InputBox("path to martif") Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile(strs, 1, -2) j = 0 Do While f.AtEndOfStream True rets = f.ReadLine lab1: lgd = Len(rets) If (Left... See more which is more or less straightforward, and then use my macro for converting martif to xls below - the resulting xls is in unicode, by the way. Sub mtf2xls() Dim fs, a, strs, rets, langs(10) Flag = 0 strs = InputBox("path to martif") Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile(strs, 1, -2) j = 0 Do While f.AtEndOfStream True rets = f.ReadLine lab1: lgd = Len(rets) If (Left(rets, 1) = " ") Then lgk = lgd - 1 rets = Right(rets, lgk) GoTo lab1 End If If Left(rets, 10) = " ▲ Collapse | | | | Wilmer Brouwer Netherlands Local time: 02:47 English to Dutch + ... TOPIC STARTER None of the options seems to do anything | Jul 20, 2010 |
thank you for your reply. I think my question is more basic than you expect. When I open a termbase nothing happens. No errors, just nothing. I now discovered that if I open a project and then the termbase for some reason I can open the termbase. But then when I click on the option to export to martif or any of the other options nothing happens. I think the termbase may be locked with a password, but i do not receive an error message that this is the case. | |
|
|
Hi Antonin, This macro is just what I am looking for. But how do you use it exactly? Best regards, Gillian | | | using my mtf2xls macro | Jul 22, 2010 |
Copy and paste it to a module in MS Excel VBA - I still use the hidden "Personal" book which was in fashion long time ago but I find this approach satisfactory; anyway, pasting it to any VBA module will work, I suppose. Running the macro from Excel: it asks for a full path to a martif file, from which an xls file is generated. Antonin
[Edited at 2010-07-22 11:38 GMT] | | |
Thanks Antonin, it is working perfectly now. I can finally export all the received dictionaries, clean them up and put them in my main dictionary. Cheers, Jill | | | You are welcome | Jul 22, 2010 |
Glad to hear that this macro, which I originally wrote more or less for myself only (hence no bells and whistles), helps other people as well.![](https://cfcdn.proz.com/images/bb/smiles/icon_smile.gif) Antonin | |
|
|
Easy to use and very effective macro. Thank you | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Export mdb file from termstar nxt? Trados Studio 2022 Freelance | The leading translation software used by over 270,000 translators.
Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop
and cloud solution, empowering you to work in the most efficient and cost-effective way.
More info » |
| Trados Business Manager Lite | Create customer quotes and invoices from within Trados Studio
Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |