What are Macros?

[Guest]

I've been learing how to do real estate valuations on Excel. Someone asked
me if I can do macros and I'm not exactly sure what they meant. Most of the
terminology is new to me. I've asked others and some have said they are not
a necessity. Others tried to explain and I didn't understand.

Nonethless, I would like to know. What are Macros, exactly?

Thank you.

 

[Peo Sjobom]

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Nothwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Guest]

Different developers will probably give you different answers for this
question...

But, basically, Excel macro is about "automation". Macros are for automating
manual tasks (steps). Like you got a television, and you make a remote
control (a macro) to control that TV.

Microsoft Excel (and Office) is composed of many many "objects". Everything
you see and use in Excel is an object. For example, a worksheet object, a
chart object. Each object has its properties. E.g. value of a cell is a
property of a cell; Color of a cell, etc. You can take an action to set an
object's property.

So, with macro, you can control Excel by changing the properties of the many
objects in Excel.

Excel macro is also basically Visual Basic language. You learn to write
macros, you're actually learning to write in Visual Basic. But you write the
language in MS Office's development environment called "Visual Basic Editor".

Because Visual Basic is a powerful language, you can also use those powerful
statements such as "conditional statements" (like IF-THEN) to make the macro
decide and "think" for you.

Overall, theoratically, you can say that anything which you can do manually
in Excel can be automated using Excel macros.

It's also worth reading a book on this topic. I'm sure you'll find it very
interesting and useful.

Regards,
Edwin Tam
(e-mail address removed)
http://www.vonixx.com

 

[Guest]

start tomorrow(or tuesday!)Instead of doing a repetitive or involvd series of
simple tasks get a macro to do it for you.At the start of one of these
operations go to tools macro and record new macro.When you through your copy
and paste routines opening other workbooks or selecting different sheets the
recorder will be doing as you do.At the end press the Stop recording
button.If you go to tools,macros again
you will see macro1.if you click on macro 1 then click edit you will see
your actions in visual basic.if you then set u your spreadsheet exactly as it
was before you recorded those actions and click run it will run through the
same steps in the blink of an eye