Avoid repeated: create a Word macro

Repeated input of the same information in the document after document, always and always... There must be a quicker way, right? You can save Word macros time (and possibly some reason) by to automate repetitive tasks.

Suppose you are a real estate agent. Every time, when you sell a home, you need name and address of the customer, the documents added. Create a macro to automate addition of all contact information of the customer, where whatever you need.

Creating a macro is straightforward and does not require programming skills. You simply say Word when you start and stop recording a series of steps; Type, for example, from at the start a client name, when you are finished. Then Word will all these steps automatically when you click a button or enter a shortcut key, you the macro assigned to the.

Here is a step by step:

1. Go to the view click the macros tab drop - down-list and select record macro.

In the dialog box to record a macro , you're going to call and describe your macro, and then select whether you want to run it on a key or key combination.

2. In the macro name box  dialog box, type your macro a name that contains no spaces, e.g., AdamSmith instead of Adam Smith.

3. The ' Description ' field is for you. In the course of time, you can create dozens of macros and anger might remember what is what. Give a description of you, out helps.

4. In the box store macro in determine whether the macro is running in the current document or all documents. Select the option--to run in all documentsall documents-.

5. Choose, whether you use a link or button, the macro run, by clicking on the button or keyboard symbols. For this exercise, click.

After you click,you can word your button to place add light-the toolbar for quick accessyou can find.

1. In the field of Word options/Quick Access toolbar , click the name of the macro, and click Add to include it on the list of the other commands on the Quick Access toolbar.

 

To ensure that you can identify the button on the toolbar, select a button.

2. Click on the change, and then select a button from the dozens available.

Once you select your button and click on OK, starts the macro is running, that record your keystrokes until you stop recording. For example, I chose the button of a man, wearing a tie, you click on OK, and the macro started, lived in Lincoln, entered Nebraska recording a fictitious client named Adam Smith's address. As I finished typing, I clicked stop recording the macro - drop-down list.

Here is how you can do:

1. Inthe dialog box changebutton , select a button, and then click OK.

2. Click OK again in the Word Options and starts to macros.

3. Lead the actions that you want to include in your macro.

4. Once you have performed the actions, gomacro tab on the viewtab, and then click stop recording.

5. You now see that the macro button appears on the toolbar for quick access. Just click and the same actions that you recorded to happen again, where to put the cursor in a document. They see this button on the toolbar for quick access in all Word documents if you have chosen that they once displayed only in your old.

View the original article here

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