asked on

Does word 2007/2010 macro recorder works as as it did in word 2003?

It seems to me that the macro recorder in word 2007/2010 doesn't work as it used to do in word 2003. For example, if I select an image, start the recorder, then apply some image editing (e.g. recolor the image to black and white), in word 2003 I get a full working macro, as shown in code 1. Instead, if I try the same recording in word 2007/2010, I get a macro containing only the image selection (indeed, when I start recording in word 2007/2010, the image get deselected and I have to selecte it again) as shown in code 2.

Is there a way to make word 2007/2010 record the same macros that I can record in word 2003? Or the macro recorder has been downsized for some reason?

code 1
Sub Macro3()
    Selection.InlineShapes(1).PictureFormat.ColorType = _
        msoPictureBlackAndWhite
End Sub

code 2
Sub Macro12()
    Selection.MoveLeft Unit:=wdCharacter, Count:=1, Extend:=wdExtend
End Sub

Open in new window

SOLUTION

Anastasia D. Gavanas

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Esanteva

ASKER

@xtermie: thanks, but I don't need to use another recorder, I'm only trying to understand if the official recorder in office 2007/2010 has been really downgraded with respect to the original one in office 2003.

Esanteva

ASKER

@xtermie: could you find a general pattern of what can be recorded in 2007/2010 and what can't? I mean, with respect to 2003.

SOLUTION

Anastasia D. Gavanas

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Anastasia D. Gavanas

One way to learn the terms and syntax of the object model is to use the macro recorder to record the steps taken to achieve a desired result using the mouse and menus of the application.[4] Once this is done, the VBA code constructed by the recorder can be viewed in the VBA editor, and often greatly streamlined or generalized with only a modicum of understanding of VBA itself. The macro recorder does not always record everything (particularly for graphs), and some applications employing VBA do not provide a recorder at all. Use of debugging tools to discover VBA constructs for some cases where the macro recorder does not work are described by Jelen and Syrstad,[5] but some steps may remain obscure.

I dont know if a specific list is available...I will look around, but i doubt it there is one....
you can always compare the respective object models

Esanteva

ASKER

> you can always compare the respective object models

Yes, but looking at the object model won't let me know what is recordable and what it is not in 2007/2010. That is why I was looking for a reference to information regarding the differences in 2003 and 2007/2010 macro recorders.

ASKER CERTIFIED SOLUTION

juicecap

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer