Jan Sundström wrote:
I trust Hynek, Vito, Samuel, tectranslate and you other regulars to have some really clever input to this question.
Thanks for the flowers.
An example: we have 125 text files that were exported from AutoCAD. They now have this format:
TOP PLAQUE ROBOT 4
ENVOI DE DONNES
TOP PLAQUE ROBOT 3
And you need "TOP PLAQUE ROBOT 4", "ENVOI DE DONNES" and "TOP PLAQUE ROBOT 3" translated?
I have a ready-made macro just for this purpose (provided that there isn't any text in curly brackets somewhere that DOES need to be translated.)
BUT it only works on the currently opened file right now - haven't gotten round to implementing the logic for batch processing just yet (plus, the unavailability of file dialog functions in VBA makes this unnecessarily complicated.)
So your best bet might be with Vito.
Vito, if you need any pointers on the algorithm to use, let me know.