Word 2003 Macro problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dark hunter - 13 Jan 2005 17:05 GMT

When using word 2000, I can record a macro that will paste a copy of an excel
chart into the word document, as a windows enhanced metafile, resize it, put
a line round it, centre it on a horizontal line and put it behind the text.

When I try to do this in in word 2003 I cant. It wont let me make any
formating changes to the picture other than to resize it. I cna't even paste
it and resize because it moves of the picture after pasting.

How can 2000 better at recording macro's than 2003 it's stupid. And please
no answers saying learn VB I havn't the time at work, and I have a real life
at home. Besides why should I learn VB just because MS screw up something.

I am also not interested in buying someones book so please, only helpful
answers

If this sounds a bit harsh i'm sorry but this has been stressing me out all
day, and all the other posts I find about this are replied by people trying
to sell something or whitter on how wonderfull they are because tehy know VB

Reply to this Message

Jezebel - 13 Jan 2005 20:29 GMT

Recording is not a good way to create macros, even in 2000. Saying you don't
want to learn VBA in this context is like saying you want to go somewhere on
your own in the car but don't tell me I have to learn to drive.

> When using word 2000, I can record a macro that will paste a copy of an excel
> chart into the word document, as a windows enhanced metafile, resize it, put
[quoted text clipped - 14 lines]
> day, and all the other posts I find about this are replied by people trying
> to sell something or whitter on how wonderfull they are because tehy know VB

Reply to this Message

dark hunter - 13 Jan 2005 21:41 GMT

No it's not like that at all, it works fine in 2000, without any problems at
all. yet go to do it in 2003 and hey preston it won't work. The problem lies
in office 2003 removing the functionality of macro recording. I can "drive"
2000 where ever I want, to do it in 2003 I have to spends weeks if not months
becoming an mechanic. MS expect me to spend £500 evey other 18 months
upgrading to a new version of office and remove the usibility that I got from
a previous version thats crap, but hey what else can you expect for micro(rip
you off)soft

> Recording is not a good way to create macros, even in 2000. Saying you don't
> want to learn VBA in this context is like saying you want to go somewhere on
[quoted text clipped - 26 lines]
> > to sell something or whitter on how wonderfull they are because tehy know
> VB

Reply to this Message

Charles Kenyon - 13 Jan 2005 22:02 GMT

No, Word 2003 changed the default way it handles inserted pictures, which (I
suspect) interferes with the recording of a macro. Word has never been good
at recording macros that involve mouse clicks and movements (for pretty
obvious reasons). I suspect that your insertion and modifications didn't
need the mouse in Word 2000 but do in Word 2003.

I believe that the change was to insert pictures "in line" rather than
floating by default. (I could be wrong.) I suspect you can change this
setting, in which case you may be able to continue blithely recording macros
to your heart's content. Jezebel's advice that recording macros is not a
good way to create them stands, however. It is good advice because there are
real limitations on the macro recorder (as you've discovered) and the code
it creates is seldom optimal.

As for complaints, I would suggest sending them to Microsoft rather than
addressing them to the people here who are your fellow users.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

> No it's not like that at all, it works fine in 2000, without any problems
> at
[quoted text clipped - 48 lines]
>> > know
>> VB

Reply to this Message

Jezebel - 13 Jan 2005 23:25 GMT

Default insertion for pictures is indeed a setting: Tools > Options : Edit
tab. And yes, Inline is the default.

> No, Word 2003 changed the default way it handles inserted pictures, which (I
> suspect) interferes with the recording of a macro. Word has never been good
[quoted text clipped - 60 lines]
> >> all
> >> > day, and all the other posts I find about this are replied by people

> >> trying
> >> > to sell something or whitter on how wonderfull they are because tehy
> >> > know
> >> VB

Reply to this Message