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]


 

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


 


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






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 »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »



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