- Excel VBA in Depth

Tutorial & e-learning. June 24, 2010 by bomb. - Excel VBA in Depth - Excel VBA in Depth | 161.4 MB
Genre: eLearning

In Excel: VBA in Depth, Excel and VBA expert Curt Frye introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance Excel performance and efficiency. This course introduces the Visual Basic for Applications programming language, covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel 2007 object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course.

Topics include:
Working in the Visual Basic Editor
Adding code to a macro
Creating, exporting, and deleting code modules
Declaring and using variables
Managing variable scope
Defining arrays
Managing workbooks and worksheets with VBA
Repeating tasks with loops
Debugging VBA code
Cutting, copying, and pasting cell data
Running and triggering event procedures

Download File

Here you can download files online. Unlimited access to all sources file with one click direct download link!
  • Featured link
  • [24-06-2010]