|
Are you a competent user of
Access, Excel or Word and would like to go to the next level? Or would like to know how to automate routine but complex tasks using macros? In either case, one or more of our 2 day Programming in VBA (Visual Basic for Applications) courses could be right for you. You do not have to have programming experience to do these courses but it is vital that you are very good users of the product in question. We have sourced excellent courseware from Watsonia Publishing and have supplemented this with practical examples that approximate the type of automation tasks our clients are regularly undertaking or wish to undertake with Office products. Microsoft Excel At the completion of this course you will have covered the following topics: recording and running a macro to format cells obtaining user input during a macro introduction to using variables in modules relative v absolute recording viewing a VBA module editing a VBA module automating a data consolidation process assigning a macro to a button or graphic creating user defined functions using the Immediate Window creating an Excel "add-in" file using the VBA editor using comments, breakpoints and indents testing and debugging VBA code automating the creation and manipulation of a PivotTable using VBA using variables and arrays overview of the Excel Object Model using workbook and worksheet objects prompting for user input using IF to make decisions looping through code creating and running a custom form programming custom forms creating a custom menu assigning macros to menu commands programming automatic events Our next courses are on: Tuesday 10 & Wednesday 11 October 2006 Microsoft Access At the completion of this course you will have covered the following topics: The Visual Basic Editor and converting macros to VBA Using variables and constants Standard v Class modules Making decisions in code User input and message boxes User Functions and passing parameters Objects Properties and methods Looping through code Scope of variables DAO/ADO Debugging and error handling Updating Data with SQL in Code Event Driven Programming Our next courses are on: Microsoft Word At the completion of this course you will have covered the following topics: record, run, edit and delete a macro create and run a Sub procedure open and work in the VB Editor create and work with variables create and work with functions create decision structures which will allow your program to respond to different situations create loop structures which will repeat statements for various purposes manipulate text using a variety of objects perform basic document management tasks create and run a UserForm with various controls create a simple program incorporating a UserForm create simple error handlers in your programs use Word's built-in dialog boxes in a VBA program Our next courses are on:
|