Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does a macro actually do
In excel if it is a Macro file that it updates all related workbooks. I do
not entirely understand this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does a macro actually do
Dear Robin
A macro is a recording of each command and action you perform to complete a task. Later whenever you need to carry out that task in your worksheets you just need to run the macro. They will always carry out the same steps in the same order. Complex ones can be created using the VBE but simpler ones are created by recording the macro. Try recording one from tools|Macro and view the code to understand your actions... If this post helps click Yes --------------- Jacob Skaria "Robin" wrote: In excel if it is a Macro file that it updates all related workbooks. I do not entirely understand this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does a macro actually do
Jacob,
Thank you. You explained that well. "Jacob Skaria" wrote: Dear Robin A macro is a recording of each command and action you perform to complete a task. Later whenever you need to carry out that task in your worksheets you just need to run the macro. They will always carry out the same steps in the same order. Complex ones can be created using the VBE but simpler ones are created by recording the macro. Try recording one from tools|Macro and view the code to understand your actions... If this post helps click Yes --------------- Jacob Skaria "Robin" wrote: In excel if it is a Macro file that it updates all related workbooks. I do not entirely understand this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |