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.