VBA is therefore different from the Standalone Visual Basic program used(by professional programmers) for developing commercial quality software applications _ though it borrows many of the latter's features. Think of Excel VBA as being the standalone Visual Basic software, built into Excel for the benefit of Excel users who are not necessarily programmers, but who are keen to exert more control over the application. So, Excel VB offers any interested users the necessary tools to make the application deliver more functionality. The final product is still an Excel document, but with extra functionalities added using VBA.
A DIFFERENT Type Of Automation. The approach to spreadsheet automation that I refer to, is one that seeks to provide functional spreadsheet automation alternatives for ANY spreadsheet user task(s). Typically, solutions like this would require the developer to study existing manual data recording, analysis and report generation systems, then plan _ in consultation with users _ for incorporation of automation into the spreadsheet to replace them, where possible.
2. Sourcing Capital _ For Expansion or Startup. You can make it easier for banks and prospective investors to back you financially and/or take the decision to buy into your business. Those already running their businesses will know that banks like to see detailed business records that show in real terms all aspects of a business' performance. Without detailed and comprehensive spreadsheet tracking, it might be difficult to show this. Agreed there are software applications that capture most of these. However, sometimes, you want to highlight certain scenarios or trends in a way that an off_the_shelf application cannot accommodate due to the uniqueness of your need. It is in this regard that the use of spreadsheet tracking becomes relevant.
The savings _ from using your "in house" expertise _ in terms of money and man_hours alone, will quickly justify the investment you make in "developing the needed skills" _ especially, when you compare what you spend with the cost of purchasing a commercial software application _ or even engaging the services of an Excel VB developer.