New Excel macro of training videos for beginners

Today's post was written by Angela Chu-Hatoun, senior programmer author on our large Office team, much more technical than I am that, frankly, and to explore the deep down side of programming, how it works and how can you even do it well.

This can post 13, on the MSDN Office client developer content-blog originally appeared last Friday, (display name: dev docs) and I had to Angela simply questions whether I was able to publish it here. I figure that there is a good tandem piece on my post September 2010 what is a macro and why you should use it.

Developers and power users still no programming using 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. To learn an object model for our purposes, I would like to call the first two videos in the set:

The first video in the series shows how to record a macro that fills a number of cells in a workbook. The second video shows how to view and edit the Code Visual Basic for applications (VBA) for the recorded macro in the Visual Basic Editor (a MIcrosoft programming language tool).

In General, is the application object model for Office client applications that support macro recording, use the Visual Basic Editor the code which is a convenient way to learn a recorded macro (Excel, Visio, Word) and write the code for a task, the set of actions in the application's user interface associated with. You can use the code as the basis for the recorded macro and extend the functionality by more code to achieve your purpose. Recently, I have to a similar approach to how to use the Word object model, learn to look for a string in an e-Mail message. I tried recording a Word macros in the search for a string in a Word document. Then, I have adapted the code and wrote the macro for the blog post look like to a string in an Outlook e-Mail message and automate a response that contains the string.

(Already lost a bit?) What read an string is in computer science. (This is all easier than you might think.)

If you are new to programming with the Excel object model or even Visio, or Word, watch the training videos and consider approaching the object models by recorded macros!

(Thanks Angela;) I guess really let you steal me this amazing information. People do like you is one and expand you: go to the Office Dev Docs Blog and learn some new tricks. (Well, I go this programming to explore me... abdomen)

Office partner

View the original article here