![]() 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 Comments
Leave a Reply. |