Do you not want to compile data from different worksheets and workbooks. How to go to different workbooks and pull the data from there and compile it one place. How to work with so many sheets without bothering about things – what name they have , if they will get deleted in future or if more sheets get added. These collection loops make you a great programmer. in–fact, if you do not know this you can never be a great coder. Come and fall in love with them. Immensely helpful , interesting and powerful. So much fun .
Learn how to work with workbooks and worksheets
How to open the workbooks, how to close one workbook, specific workbook or all opened workbooks
learn how to delete or add workbooks , how to jump from one workbook to another. From activate files to editing them –we are covering all.
how to select or delete or protect or rename or add the worksheets in excel.
how to define the workbooks and worksheets in a professional manner using Set Keyword. What is the advantage of declaring objects as classes.
What happens if we declare set statements anywhere in the code. Does it allowed in vba? Detailed discussion on the proper mentioning of dim and set statements while dealing with objects and classes.
Specification: Excel VBA Collection Loops – MIS Analytics Training Series3