You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Now, about that robotic vacuum I had: Perhaps I expected more than I should have from it. Perhaps the fact that the company advertised it as a "robot" made me think it could do more than just go in circles and further neuroticize my dog. Perhaps I expected it to act like a macro.
A macro is the shortcut of all shortcuts, it's an "I'm at your command" genie, it's a pattern or rule, and it's the good kind of computer gremlin. A macro is a little computer program that you — yes YOU with no computer development knowledge — can create to make your computing life easier and more efficient. Simply put, a macro is a bunch of commands grouped together as a single command that are recorded and saved under a short key code or macro name.
You can create a macro to do just about anything—to add blocks of text that you know you will need again and again in a document, to insert and format a table in Excel, and even to group objects together in Visio. Anything that you need to repeat can be recorded as a macro, saving you both time and the possibility of making a mistake.
For example, if you know that you will often use a highly stylized list, comprised of colored balls on the first level, tiny images of yourself on the second, and just an indent on the third level, you don't have to reinvent the wheel every time you want to insert this list; you only have to create it once. You use something called a macro recorder, which works very much like a tape recorder: You basically record every keystroke, every button click, every command that you need to do in order to accomplish this one task, so that the next time you need to do this possibly complex set of actions, the macro will just repeat back what it observed. It's like a monkey. Or a parrot. Or your three-year-old who repeats to his teacher everything that you've muttered under your breath to the slowpoke in front of you who hasn't the decency to even drive the speed limit during your commute to preschool that day.
You can create the very simple to the very complex macros; you just do what works for you and the task at hand.
The Excel training course Get in the loop with macros is a great place to start looking into macros, and there are a TON of other resources on the Office.com web site. Do a general search for "macros" and then whittle down the results to the program(s) you're interested in creating macros for. And once you do, I'd like to know what you came up with so maybe share them with the rest of the blog readers. A macro bared is a macro shared.
"Good ideas are not adopted automatically. They must be driven into practice with courageous patience." — Hyman Rickover
Great post admin.Thanks for sharing this nice information about macros..plz give a live video to make macro,it would be appreciated more..
@E Liquid: Take a look at this video office.microsoft.com/.../video-create-a-user-interface-ui-macro-VA101814109.aspx - it's for Access 2010 but can give you the general idea.
I also found this on a third party site that might be helpful too. www.macroexpress.com/videotutorials.htm
The term Macro is an antiquated one. It was borne out of Lotus 1, 2, 3 and featured in early versions of Excel, known as XLM, Excel Macros. But, it was quite a bit a different than what we see today, a command-line prompt script that was written directly into spreadsheets, themself.
Today, Excel features a much richer scripting language, on the back-end, based (currently) off of VB6, although it's been upgraded to VBA7. The term 'Macro' lives on, but it's a bit of a misnomer, in a historical context.
I didn't know that about the Macro term!
I never accepted it 100%. Instead of Macro I would like something like Script
I think the same think about the "Sub" term in Visual Basic.
Why not Subroutine (Complete word as in Function)
This is a great post and makes me think of where I can fit in. I do a little bit of everything mentioned here and I guess I have to find my competitive advantage.
God, Crabby YOU ARE A LIFESAVER! I have to do some scholwork using spreadsheets, and they INCLUDE USING MACROS! I found you in the Inside Office newsletter, and your blog post is a lifesaver!
What flavor lifesaver? I hope tangerine; those are my faves...:-)
This Office Blog is really great! I am in my job search stage, and i like to gain more confidence about my Microsoft Office software especially Excel and Word. Here in your blog i discovered a lot of help. I did not work for a while, so I feel I need to upgrade my skills. Your Training websites and Crabby helps me discover and explore about Excel particularly Pivot table, Macros, etc. Inter actions with your Office blogs also helps me to discover that people in the comment portions get info and suggestions from you blogs. I will keep on coming back to learn more of the update. Thank you and more power.
is this topic is talking about the Macro in word ???