Course Content

Variables And Arrays· 

• Creating variables· 
• Creating arrays· 
• Using arrays

The Excel Object Model · 

• Collections· 
• The For Each…Next Loop

Working With Files· 

• The workbooks object· 
• The Dir function· 
• Searching for files

Working With Sheets· 

• The worksheets collection· 
• The sheets collection· 
• Grouping worksheets (arrays)· 
• The window object· 
• Using Typename

Comparison Operators· 

• The Like function· 
• Using Wildcards

System Functions· 

• Val· 
• Case functions· 
• Trim functions· 
• Text functions· 
• Date functions

Application Objects· 

• Excel default information· 
• DisplayAlerts· 
• ScreenUpdating· 
• StatusBar· 
• OnTime· 
• Using Wait 

Creating User Defined Functions (UDF’s)· 

• Creating functions· 
• Adding arguments· 
• Calling functions

Working With Charts· 

• The charts collection· 
• Adding charts· 
• Amending charts

Working With Pivot Tables· 

• The pivot tables collection· 
• The pivot cache· 
• The pivot fields collection· 
• The pivot items collection

System Dialog Boxes· 

• Showing dialog boxes· 
• Using dialog boxes

Advanced User Forms· 

• Using combo boxes· 
• Using check boxes· 
• Creating and using option groups· 
• Form interaction

ActiveX Controls· 

• Multi page controls· 
• Tab strips· 
• Progress bar· Spin button· 
• Calendar

Sharing Data With Other Applications· 

• Setting references to other applications· 
• Interacting with Word · 
• Word VBA commands· 
• Interacting with Access· 
• Access VBA commands