This blog aims to summarize and gives good practices and objects to use in the context of data manipulation under VBA (Virtual Basic for Applications) in the Microsoft Office tool Excel. VBA is an object-oriented language created in 1985 and used by millions of people in the world every day.
In a world where data processing has taken a considerable scale, the Excel tool proves to be one of the most used daily by companies (Finance, Marketing, HR, Accounting, Business, Science…) and individuals. The VBA development language integrated into Excel optimizes, automates, and promotes efficiency through the macro implementation of the procedures (Sub) or functions inside modules, which designates a series of instructions. You will be able to manipulate hundreds of thousands of data within fractions of seconds or a few minutes if the algorithmic logic implemented is optimal.
VBA is present in Microsoft Office applications, including Office for Mac OS and Windows. However, it is challenging to program a code compatible with both Windows and Mac.
Articles in this blog will be updated and improved over time, focusing on the fundamentals of VBA macro programming. The mastery and knowledge of these articles will make you a great developer in VBA and will allow you to improve your algorithmic skills.
Do you want to improve your knowledge and skills in writing your VBA applications? You have no VBA experience, you are a new programmer, or are you already a good developer? Don’t worry, you will learn in this blog to handle the Excel objects with VBA as rows, columns, sheets, workbooks, range, and cells that are the keys elements of your spreadsheet. You will also learn how VBA can interact with Microsoft Office applications as Outlook to send automatic email, Word, PowerPoint, and manipulate the Windows project explorer.
To handle huge data, you will see useful concepts like a dictionary or how to create your custom objects with class modules. You will find here several tips and tricks to learn, discover, and improve your developer skills. To go further, in the era of data handling, you will see how you can reconcile a powerful open-source language Python and VBA.
VBA is object-oriented programming (OOP). You can custom your classes. However, this part of the VBA language has some limitations. Several principles of object-oriented programming are not available such as inheritance or polymorphism. To override, we will see different methods exist.
The limits of VBA programming will be whatever you decide to put yourself.
VBA is a simple language, easily accessible that requires just an installation of the Office pack. This programming language is powerful when used well.
The VBA Editor is already in the Microsoft Office application (use the keyboard shortcut Alt + F11 to open it or Fn + Alt + F11 for Mac OS users).
The people behind this blog are not employees of any software companies. Just daily workers who want to share knowledge.
Don’t hesitate to leave your comments and opinions on these articles. It will help to improve this blog according to everyone’s needs.
Thanks for your support & enjoy your visit.