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.
Today's post was written by Angela Chu-Hatoun, a senior programmer writer on our big Office team who's, frankly, much more technical than I am and is good at exploring the deep underbelly of programming, how it works, and how YOU can do it too.
This post originally appeared last Friday, May 13, on the MSDN Office Client Developer Content blog (friendly name: Dev Docs) and I just HAD to ask Angela if I could post it here, too. I figure it's a good tandem piece to my September 2010 post What is a macro and why you should care.
Developers and power users new to programming with the Excel object model take note: there is a new series of videos that show how to create, edit, and run macros in Excel 2010: Save time by creating and running macros in Excel 2010.
This set of four videos ranges in length from three to five minutes each. For our purpose of learning an object model, I'd like to call out the first two videos in the set:
In general, for Office client applications that support macro recording, using the Visual Basic Editor to look at the code of a recorded macro (Excel, Visio, Word) is a convenient way to learn the application's object model and how to write the code for a task that maps to a series of actions in the application's user interface. You can use the code for the recorded macro as a baseline, and extend its functionality by writing further code to achieve your purpose. Recently I used a similar approach to learn how to use the Word object model to search for a string in an email message. I tried recording a Word macro of searching for a string in a Word document. Then I adapted the code and wrote the macro for the blog post How to search for a string in an Outlook email message and automate a reply that contains the string.
(Already a bit lost? Read up on what a string is in computer programming. This is all easier than you might think.)
If you are new to programming with the Excel object model, or even Visio or Word, do take a look at the training videos and consider approaching the object models through recorded macros!
(Thanks Angela; I really appreciate you letting me pilfer this amazing information. Folks, do yourself a favor and stretch yourself: Head over to the Office Dev Docs blog and learn some new tricks. Now, off I go to explore that programming underbelly myself...)
One of my favorite features of Excel macro programming is the "use relative reference" . Previously, one could program a sort routine (for example) on one sheet of a work book, then apply this same macro to other sheets in the same workbook without regrard to column or row size. This feature does not work in the Excel 2010. What am I missing?
@beaverjohnson: I'm going to check this out and get back to you ASAP. Thanks for letting me know about that.
I have no blog yet, And I want to create a blog for my own. Please help me how.
@ Jan: There are lots of places to start a blog - one of my favorites is Wordpress: en.wordpress.com/signup
@Beaverjohnson Still trying to find the answer to your question; I haven't forgotten aobut you!
@beaverjohnson, this is what I found out from an Excel expert over here:: "Regarding the statement on applying macros I don’t think this is true. VBA in Excel specifically allows the developer to target any sheets in the workbook, and apply whatever action on any sheet. The Range object (pivotal in Excel) can be applied to all sheets as well."
At this point, I suggest you take your question to Microsfot Answers and see what you come up wiht there: answers.microsoft.com/.../default.aspx