Move exported Excel files to the appropriate subfolders
Thread poster: Hans Lenting

Hans Lenting  Identity Verified
Netherlands
Member (2006)
German to Dutch
May 11

When you have to translate a project that consists of many Excel files in several subfolders, CafeTran Espresso 2018 will import all of them with no hassle.

However, when you're ready and want to export the translated files, you can only export to one folder.

Here's a macro to move all exported files to the appropriate subfolders. You'll have to export to the Export folder on your Desktop and to place (a copy of) all imported files in the correct subfolders in the Import folder on your Desktop. (E.g. unzip the ZIP file that you received to the Desktop and rename the top level folder to Import.)

zq94sdvdvkm8jlti36qq.png

Download the macro at: https://forum.keyboardmaestro.com/uploads/default/original/3X/4/4/44c86cc99e2e1176f06375825e7be04338797daf.kmmacros

Edit: I'll change the macro so that you'll be able to select the Import folder (which normally will be the name of the unzipped ZIP package).

[Edited at 2018-05-12 16:41 GMT]


Direct link Reply with quote
 

Hans Lenting  Identity Verified
Netherlands
Member (2006)
German to Dutch
TOPIC STARTER
Updated macro May 22

I'll change the macro so that you'll be able to select the Import folder (which normally will be the name of the unzipped ZIP package).


It took me a while to get there, but here it is:

w6opqluh8ow5qhhaipyp.png

The new version of the macro (I've changed the name), can be found here:

https://forum.keyboardmaestro.com/uploads/default/original/3X/9/8/98c5a6ebaae7d6f2b773f0ac87057b8dc09e52e7.kmmacros


Direct link Reply with quote
 


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

Moderator(s) of this forum
Natalie[Call to this topic]

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

Move exported Excel files to the appropriate subfolders

Advanced search






SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
SDL Trados Studio 2017 only €495 / $595
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 €495 / $595 / £425 / ¥70,000 You will also receive FREE access to Studio 2019 when released.

More info »



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