Catalyst Financial Analytics Institute

About VBA

VBA is an object-oriented programming language and well suited to beginners.  It provides many of the Visual Basic programming facilities through the Excel application. Thus, students who have access to Excel can gain familiarity with Visual Basic without having to set up to the full blown program. With VBA, programmers have the power to customize Excel application that would be impossible to achieve with Excel alone. VBA can often provide a faster, and sometimes easier –to- implement solution, than could be achieved  with Excel alone. Excel is made up of a series of objects that can be manipulated through code. All these objects are required to complete various tasks while using Excel. For instance, if an Excel financial report form is complete, the user might open the workbook containing a worksheet with the report from, enter data in a range on that form, and save the workbook, The workbook, worksheet and range are all excel objects, VBA can be used to manipulate such objects, making it easier to complete the task of submitting the financial report. E-mailing the report can also be automated.

Advantages to have macros(VBA) in my excel sheets.

• Making programmes as size, every company has its peculiarities and characteristics, in many occasions packages of standardized software are acquired and they do not fulfill the initial expectations. They do not contribute to any real solution. Through the macros in excel each programme fits easily to each type of company, providing versatility and flexibility.
• Quickly and easy handling of the programmes developed with Excel: when the companies acquire new software, it has to dedicate time to handling it. The great advantage that it offers to us is that they are developed with excel, a known tool by the majority people in the company.
• Increase of effectiveness and efficiency of the work since we reduce hours and hours of our work making manual tasks when turning them automatic, occupying the time gained in other matters.