Technical forums » CafeTran support »
Move exported Excel files to the appropriate subfolders
Thread poster: CafeTran Trainer
CafeTran Trainer
CafeTran Trainer
Netherlands
Member (2006)
May 11, 2018

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 subfolder... See more
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.)

Untitled

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] ▲ Collapse
 
CafeTran Trainer
CafeTran Trainer
Netherlands
Member (2006)
TOPIC STARTER
Updated macro May 22, 2018

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:

NewMacroVersion

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
 


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






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »
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 »