/$$ /$$$$$$$ /$$$$$$ /$$ /$$ /$$ /$$$$$$ /$$$$$$
|__/| $$ $$ /$$ $$| $$$ | $$|__/ /$$__ $$ /$$__ $$
/$$| $$ \ $$| $$ \ $$| $$$$| $$ /$$| $$ \__/| $$ \ $$
| $$| $$$$$$$/| $$ | $$| $$ $$ $$| $$| $$$$$$ | $$ | $$
| $$| $$__ $$| $$ | $$| $$ $$$$| $$ \____ $$| $$ | $$
| $$| $$ \ $$| $$ | $$| $$\ $$$| $$ /$$ \ $$| $$ | $$
| $$| $$**| $$| $$$$$$/| $$ \ $$| $$|**$$$$$$/| $$$$$$/
|**/|*****|**/ \******/ |**/ \**/|**/ \******/ \******/
TiTLE: Lynda.com.Excel.2010.Tutorials.Macros.in.Depth-iRONiSO
TYPE : BOOKWARE Cracker : iRONiSO
FiLE : 25 X 15MB PACKAGER : iRONiSO
TOTAL : 1 * DVD9 SUPPLiER : TEAM iRON
PLATFORM : WINDOWS FORMAT : Bin/Cue
RLS DATE : 23/01/11 PROTECTiON : NONE
Course Contents
Introduction
Welcome
Using the exercise files
1. Getting Started
Understanding what a macro does
Reviewing macro examples
Understanding security
Reviewing the recording method
Understanding other techniques for macros
2. Running a Macro (Execute, Play Back, Etc.)
Running macros from the View tab
Running macros from a keyboard shortcut
Running macros from the Quick Access toolbar button
Running macros from an object or clip art
3. Using Visual Basic for Applications (VBA)
Introducing the VBA environment
Viewing the VBA components
4. Recording a Macro in Stages
Recording a simple macro
Adding functionality to a macro
5. Creating Non-Recordable VBA Code
Understanding absolute and relative references
Using For and For...Next statements
Using Do...While and Do...Until statements
Creating interactive macros
6. Macro Project: Converting a Mailing List into a Database List
Planning a macro
Recording partial code
Using loop structures in context
Testing a macro in Step mode
Pulling the data together
Joining two macros
Streamlining macros
7. The Personal Macro Workbook
Creating a personal macro workbook for macros with wide applicability
Closing and updating the personal macro workbook
Conclusion
Final thoughts
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!! For Additional info !!!!!!!!!!!!!!!!!!!!!!!!
http://www.lynda.com/home/DisplayCourse.aspx?lpk2=74463
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!! GROUP NEWS !!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!! Web access Training Library's / Education video's !!!!!!!!!
!!!!!!!!! Online Training Library Access / Coders are Welcome !!!!!!!!!
!!!!!!!!! Anything if u think can be helpful in e-Learning !!!!!!!!!
!!!!!!!!! Team Dump and 100 Mbpit BNC's !!!!!!!!!
!!!!!!!!! .no / Asia Affilations !!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!! Contact Information: wearenowhere@hush.ai !!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!! If You Like The Release Please Purchase As It Is Required For !!!!
!!!! All As It Got Lot Of Balls To Make It Online For People Like !!!!
!!!! You And Me As They Deserves The Best. :) !!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!