What the text books say –
Automation or automatic control, is the use of various control systems for operating equipment or applications with minimal or reduced human intervention. Some processes have been completely automated.
The biggest benefit of automation is that it saves labour, however, it is also used to save energy and materials and to improve quality, accuracy and precision
What Gilding & Company say–
Excel automation is what turns Excel from being a great product into a brilliant product. Tucked away in the background behind Excel is something called VBA or Visual Basic for Applications. This is a programming language that allows you to instruct Excel what to do in very fine detail. VBA can open and close other files, move data around and a thousand other things. With VBA you can complete extremely complex tasks just by clicking on a button. Tasks that would have taken you days to do can be completed in the time it takes you to make a cup of coffee.
The up side is plain to see, it’s quick and it’s accurate. The down side is that VBA is unforgiving. If you start adding rows or columns to a sheet the VBA won’t be able to find what it’s looking for and the button you clicked and loved so much will just not work anymore. All that this means in practice is that if you have a spreadsheet using lots of VBA you will probably need help changing or updating it.
This shouldn’t put you off. Excel Automation is stunningly powerful and can significantly increase your productivity.
- "When I needed expert help to build an Excel analysis tool, which would generate high quality reporting output, I had no particular views on which supplier I would choose to support me with this. I made contact with three companies and within 24 hours it was already quite clear to me that Gilding & Co were the team I wanted to work with. They were friendly, approachable, well-informed and entirely professional and within this short space of time (while I was still fielding technical questions from one other supplier and had not yet managed to connect with the third) had given me confidence that they both understood my business requirement and could deliver this for me at reasonable cost and within my deadlines. This impression was absolutely borne out as they worked to complete my project. The questions they asked and points raised along the way were always thought-provoking and helpful, they were both highly responsive and extremely patient as my specifications evolved, and have delivered a fantastic end-product with which I am delighted."Katherine Thomas - Director Emmanuel Gobillot