In an old cartoon was promoted a saying: “Cats and mice can be friends”. Consequently, Excel and Power BI can also be friends! Power BI allows you to import Excel reports, whether traditional, Pivot or Power Pivot reports. This is not a whole new topic, but I think it would be nice to remember it in a new light, with an emphasis on what you can do for free and when you definitely have to buy licenses.
This collection allows you to work with a variety of subordinate objects, change properties, and run methods for manipulating workbooks. Further it allows you to add new, open, save, close the workbooks… It also enables the opening of external links, document protection and all other operations to control workbooks in order to improve the experience of working in Excel.
VBA uses objects to control Excel behavior so if you want to master this programming language and make the most of it you need to get acquainted with objects and collections, as well as with their properties and methods. In this text, I will introduce you to the most frequently used Excel objects: Application, Workbooks, Worksheets, Cells … In some of the following articles, we will deal more closely with each of them.