| DEVELOPING MS OFFICE WITH |
Excel Objects• Application• Worksheet • Range • Overview of Others Access Objects• DoCmd• Overview of Others Userforms and Dialog Boxes• InputBox• MsgBox • Userforms • Creating • Adding Controls • Setting Properties • Event Procedures Debugging• Definition• Stepping through Code • Setting Breakpoints • The Immediate Window • Watch Expressions • The Call Stack Error Handling• Run-time errors• Trapping errors • Using On Errorv • Resume and Resume Next • Using GoTo Using Data Access Objects (DAO)• The DAO Object Model• Working the Recordset Objects • Recordset methods and properties Integrating MS Office Applications• Automation/OLE concepts• Object Libraries and setting References • Using GetObject and CreateObject • Using the New keyword | |
| VISUAL BASIC FOR APPLICATIONS | ||
| Duration - 4 Days | ||
|
Delegates should have completed both Introductory and Advanced courses in all the office elements prior to attending. Alternatively they should have a good working knowledge of the advanced features. Introduction to Word & Excel Macros• Recording• Executing • Editing • Development Environment • Creating an Excel Add-In • Creating Word Templates Introduction to Access Macros• Creating/Writing• Differences to other Office Applications • Macros versus VBA VBA Fundamentals• Variables and Constants• Arrays • Decision Structures • Looping Structures • Procedures • Functions • Scope Object Models• Objects, Methods, Properties and Collections• The Object Browser • Object Variables • VBA Special Control Structures Word Objects• Application• Document Template • Overview of Others |
||
