Currently, many applications have a web interface and therefore it is important to build automation to test the product or perform recurrent tasks and retreive information in particular sections.
Of course many test automation tools exists but they requires to pay a license which is often expensive.
In my work of software engineer, I have found it useful to know how to automate the Internet Explorer with VBA to extract so value or add some information.
As a localization engineer, it is important to build your own tool and automate the different repetitive tasks to keep quality, efficiency and deadlines.
In order to achieve this challenge, many applications such as Microsoft Office, Trados etc… have an OLE functionality (Object Linking and Embedding) which allows to interact between all these applications.
Among all the programming languages, the most used ones are PERL, PYTHON, VBA to code your own process automation.
In this article, I will show some examples of interaction between applications.
Shared projects