what is a macro?
in [General]
|
From: sheila on 19 Feb 2010 11:57 I would like to know what is a macro and what are they useful for?
From: Jim Thomlinson on 19 Feb 2010 12:18 XL can be manipulated using a progamming language called VBA or Visual Basic for Applications. The average user has the ability to get XL to write code for them in this language by recording a macro. When played back the macro will repeat those actions that were recorded. This is handy for tasks that you need to do over and over as you can just replay the macro each time you need to do those actions. Here is a resource on getting started with macros... http://www.mvps.org/dmcritchie/excel/getstarted.htm Macros can also be written by hand if you understand VBA and at that point a whole new world of automation of XL is opened up allowing XL to do some pretty amazing things. -- HTH... Jim Thomlinson "sheila" wrote: > I would like to know what is a macro and what are they useful for?
|
Pages: 1 Prev: how do I put quotes around a field in Excel 2007 Next: 2003 Excel regarding commissions |