By: Vlad Vistac
Submitted: 2010-08-18 14:33:11 | Word Count: 510
Get Excel VBA Training And Forget The Macro Recoorder
Most people's first exposure to Excxel VBA (Visuasl Basic for Applicaions) inovlves recording a maro. As the user performs a series of steps (for example oening a workbook going to a particular worksheet, copyig some data, etc) xEcel faithfully records each step by creating the necessarry VBA code. Each time the user runs the macro, the steps are repayed exactly as they were recorded.
[ advertisement ]
Recording macroos is grewat for really simple tasks such as producing a strait-forward report. However, theere are distinct limitations to this approach. Firstly, because Excel plays back the stps just as they were originally performed, recorded macros are notoriously slow.
Secondly, recorded macros will only run properly under the conditions in which they were originlaly rceorded. For example, if a partiuclar worksheet neeeds to be active at a certain point and it is not active when the macro is pllayed back, an errtor will occur.
This meeans, effectively, that recorded macos can only really be used by the prson who reorded them. They cannot be distributed to one's work colleagues.
One of the firsst things we find we have to do on the Excel VBA training courses that we run at our London training centre is to steeer uesrs away from the macro recorder. We offer them a good grasp of the Excel object model, a way of programmatically encoding each of the elements witihn the Exccel environment such as the application itself, wiorkbooks, worksheets and cell ranges.
Admitedly, Excel VBA can be difficult to grsp for those usrs who have done little or no programming. This is one reason why we prefer to run a five day intensve Excel VBA training coursde aimd at people new to VBA. We find that this apprpoach giives everyone a chance to gain confidence and familuiarity with this o environment.
After weanming users off the macro recorder, we epxlain to them the syntax and structure of VBA. They learn how to use variables to store both data and references to Excel obejcts, how to code logical and iterative structures and how to allow the pertson running a macro to choose bewteen different optionns.
Getting some training on Excel VBA is always worth the efffort. It can take the productivity of an Excel user to a new level very rapidly. Monthly procedures and reports which used to take long hours can suddenly be accomplished with astoudning ease and lightening speed.
Getting trained on Excel VBA is the only real way of losing one's initial dependnecy on the marco recorder. However, the recorder will always have its uses. For example, when one is wokring with an Excel obect or procedure whih is programmatically complex, recording a few steps then examining code generated is an excellent way to learn new syntax.
Author Resource:-
Learn more about buy dreamweaver Thank you
