One way of getting the VBA code is to record the macro and take the code it generates. If you prefer learning in an interactive way, you can see all of our classroom and online VBA courses here (and get to meet the owls behind the videos!).Using Excel Macros can speed up work and save you a lot of time.
Just click on any of the links above to see a complete listing for that category of VBA videos. Object-oriented programming in VBA: creating and using classes and structures to encapsulate the logic of an object (including understanding properties, methods and collections).
Using VBA to scrape websites (that is, to download the HTML content and programmatically parse this to extract content).Ĭreating, editing, looping over and deleting shapes (including text boxes, regular polygons and call-outs) using VBA. Getting VBA to work with recordsets of data from Access or SQL Server, or any other data source for that matter. Videos on how to use some of the built-in VBA functions, and also videos on working with specific data types such as strings and dates. Using Outlook with VBA, including how to create emails and loop through folders in Outlook. Linking Excel, Word, PowerPoint, Outlook and other Microsoft Office applications programmatically. Using FileSystemObjects to manipulate files and folders, and saving data as PDF files. Miscellaneous additional VBA topics which don't fit conveniently into any other category (including working with arrays, ByRef and ByVal arguments and much more). Using VBA to create and manipulate charts, including how to conditionally format them. Videos on how to programmatically manipulate pivot tables, charts and PowerPivot within Excel. You can draw custom dialog boxes in VBA called user forms, and manipulate their controls using VBA (as this series of tutorials will teach you). This set of videos roughly follows the contents of our two-day introduction to VBA course.
0 kommentar(er)
