Lynda.com - Excel VBA in Depth

English | H264 960x540 | MP3 96 Kbps | 184 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



Screenshot



Download

http://hotfile.com/dl/50218589/ae86d3d/shareislove_LYDEXVBAiD.rar.html

or

http://www.fileserve.com/file/Wws6cK...LYDEXVBAiD.rar