Word 2007 and my macros?

We just got the word - we will be "upgrading" to Office 2007 shortly.

I _live_ by my macros! If they worked fine in Word 2000 and 2003,
will they still work in 2007?

I figure I need to make a backup of my Normal and templates. I know
the toolbars won't show up in 2007, and any macros that show or hide
toolbars on open or close won't work. If I clean these macros out of
my files, should everything else be mostly okay?

Ed

Graham
Wed May 14 07:27:49 PDT 2008

Ed from AZ wrote:
> We just got the word - we will be "upgrading" to Office 2007 shortly.
>
> I _live_ by my macros! If they worked fine in Word 2000 and 2003,
> will they still work in 2007?

Most of them should work, the notable exception being those that employ
autotext, which will have to be modified.

> I figure I need to make a backup of my Normal and templates. I know
> the toolbars won't show up in 2007, and any macros that show or hide
> toolbars on open or close won't work. If I clean these macros out of
> my files, should everything else be mostly okay?

The *custom* toolbars will show up in Word 2007 and you can show and hide
those toolbars, though frankly there isn't a lot of point - see
http://www.gmayor.com/Toolbars_in_word_2007.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Ed
Wed May 14 08:03:22 PDT 2008

Hi, Graham. Thanks for responding.

> > We just got the word - we will be "upgrading" to Office 2007 shortly.
> > I _live_ by my macros! =A0If they worked fine in Word 2000 and 2003,
> > will they still work in 2007?
>
> Most of them should work, the notable exception being those that employ
> autotext, which will have to be modified.

I don't use AutoText, either in my normal work or in macros. So I'm
safe there.


> > I know the toolbars won't show up in 2007
>
> The *custom* toolbars will show up in Word 2007 and you can show and hide
> those toolbars, though frankly there isn't a lot of point - seehttp://www.=
gmayor.com/Toolbars_in_word_2007.htm

Somehow I got the idea that additional toolbars I have created to hold
custom buttons for my macros would not appear?? I thought only the
ribbon was visible. Then again, I have never seen the ribbon except
in screen shots. A friend has 2007 at home and predicts a wave of
poor productivity and an overwhelmed Help Desk!

I am thinking about Pat's add-in, as there is no way I could get them
to install 2003 alongside 2007.

Ed

John
Wed May 14 08:30:09 PDT 2008

Ed from AZ wrote:
> Hi, Graham. Thanks for responding.
>
>>> We just got the word - we will be "upgrading" to Office 2007 shortly.
>>> I _live_ by my macros! If they worked fine in Word 2000 and 2003,
>>> will they still work in 2007?
>> Most of them should work, the notable exception being those that employ
>> autotext, which will have to be modified.
>
> I don't use AutoText, either in my normal work or in macros. So I'm
> safe there.
>
>
>>> I know the toolbars won't show up in 2007
>> The *custom* toolbars will show up in Word 2007 and you can show and hide
>> those toolbars, though frankly there isn't a lot of point - seehttp://www.gmayor.com/Toolbars_in_word_2007.htm
>
> Somehow I got the idea that additional toolbars I have created to hold
> custom buttons for my macros would not appear?? I thought only the
> ribbon was visible. Then again, I have never seen the ribbon except
> in screen shots. A friend has 2007 at home and predicts a wave of
> poor productivity and an overwhelmed Help Desk!
>
> I am thinking about Pat's add-in, as there is no way I could get them
> to install 2003 alongside 2007.
>
> Ed

I am sorry for you for having to deal with Word 2007. Although
customizing the ribbon is a nice approach, consider Classic Menu:

http://www.addintools.com/english/menuoffice/?gclid=CNv1oc-mppMCFRaHMAoddmVWnQ

It won't bring you back to Word 2003, but at least, it will help you
deal with the mess MS has made of an already complex piece of Software.

I consider Word 2007 is to Word 97 what Vista is to XP.

--
John Doue

Graham
Wed May 14 22:44:12 PDT 2008

Ed from AZ wrote:
> Hi, Graham. Thanks for responding.

> A friend has 2007 at home and predicts a wave of
> poor productivity and an overwhelmed Help Desk!

Yourt friend is right - the learning curve is steep. Businesses that throw
2007 into the mix without providing the extra training resources are going
to suffer the consequences.

>
> I am thinking about Pat's add-in, as there is no way I could get them
> to install 2003 alongside 2007.

You missed the point. There is no need to install Word 2003 alongside 2007
to use custom toolbars that are already contained in 2003 document templates
(Keeping a copy of 2003 for support would not be a bad plan however). They
will appear on the add-ins tab. the Ribbon Editor is a fine tool, but
doesn't get over the fact that Word 2007 and 2003 are not the same.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Tony
Thu May 15 01:26:51 PDT 2008

> the notable exception being those that employ autotext, which will have to
> be modified.

Is that true?

I know, of course, that you can use Building blocks instead but I thought
old code would still run correctly.

--
Enjoy,
Tony

"Graham Mayor" <gmayor@REMOVETHISmvps.org> wrote in message
news:O5NFw6ctIHA.552@TK2MSFTNGP06.phx.gbl...
> Ed from AZ wrote:
>> We just got the word - we will be "upgrading" to Office 2007 shortly.
>>
>> I _live_ by my macros! If they worked fine in Word 2000 and 2003,
>> will they still work in 2007?
>
> Most of them should work, the notable exception being those that employ
> autotext, which will have to be modified.
>
>> I figure I need to make a backup of my Normal and templates. I know
>> the toolbars won't show up in 2007, and any macros that show or hide
>> toolbars on open or close won't work. If I clean these macros out of
>> my files, should everything else be mostly okay?
>
> The *custom* toolbars will show up in Word 2007 and you can show and hide
> those toolbars, though frankly there isn't a lot of point - see
> http://www.gmayor.com/Toolbars_in_word_2007.htm
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>

Graham
Thu May 15 02:57:01 PDT 2008

None of my macros that used Autotext ran in Word 2007 eg in Word 2003
NormalTemplate.AutoTextEntries("AutoTextName").etc

Word 2007 required
NormalTemplate.BuildingBlockEntries("AutoTextName").etc

I suspect the problem was something to do with the installation of 2007
which when converting the entries may not have categorized the entries in
the autotext gallery so the macro could not find them. I have retested and
either will work as long as the entries are listed in the correct gallery.

Unfortunately I can not easily go back to the original install condition to
re-live exactly what the installation does with the autotexts from
normal.dot. Suffice to say that I had to rework the macros that used
autotext at the time, which irked somewhat :(.

Shall we say that it *should* work? The learning curve for 2007 is steep
enough, without this sort of detail ;)

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Tony Jollans wrote:
>> the notable exception being those that employ autotext, which will
>> have to be modified.
>
> Is that true?
>
> I know, of course, that you can use Building blocks instead but I
> thought old code would still run correctly.
>
>
> "Graham Mayor" <gmayor@REMOVETHISmvps.org> wrote in message
> news:O5NFw6ctIHA.552@TK2MSFTNGP06.phx.gbl...
>> Ed from AZ wrote:
>>> We just got the word - we will be "upgrading" to Office 2007
>>> shortly. I _live_ by my macros! If they worked fine in Word 2000 and
>>> 2003,
>>> will they still work in 2007?
>>
>> Most of them should work, the notable exception being those that
>> employ autotext, which will have to be modified.
>>
>>> I figure I need to make a backup of my Normal and templates. I know
>>> the toolbars won't show up in 2007, and any macros that show or hide
>>> toolbars on open or close won't work. If I clean these macros out
>>> of my files, should everything else be mostly okay?
>>
>> The *custom* toolbars will show up in Word 2007 and you can show and
>> hide those toolbars, though frankly there isn't a lot of point - see
>> http://www.gmayor.com/Toolbars_in_word_2007.htm
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Ed
Thu May 15 06:48:37 PDT 2008

On May 14, 10:44=A0pm, "Graham Mayor" <gma...@REMOVETHISmvps.org> wrote:
> You missed the point. There is no need to install Word 2003 alongside 2007=

> to use custom toolbars that are already contained in 2003 document templat=
es
> (Keeping a copy of 2003 for support would not be a bad plan however). They=

> will appear on the add-ins tab. the Ribbon Editor is a fine tool, but
> doesn't get over the fact that Word 2007 and 2003 are not the same.

So if I have a 203 template called MyMacros.dot, and make sure the
custom toolbars I use are attached to that template, then I can make
this template an add-in in 2007 and the toolbars _should_ (fingers
crossed!) be available in the Ribbon?

Well, that's better than nothing. I'm glad the 2007 team at least
threw us a bone. I'm a fairly light-weight "power user", but what I
have I use constantly. I can only imagine what some have had to go
through.

Ed

Graham
Thu May 15 07:19:57 PDT 2008

Essentially yes - To ensure that the toolbar appears make sure that it is
displayed and preferably 'floating' over the template document space before
saving the template you intend to use in this manner.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Ed from AZ wrote:
> On May 14, 10:44 pm, "Graham Mayor" <gma...@REMOVETHISmvps.org> wrote:
>> You missed the point. There is no need to install Word 2003
>> alongside 2007 to use custom toolbars that are already contained in
>> 2003 document templates (Keeping a copy of 2003 for support would
>> not be a bad plan however). They will appear on the add-ins tab. the
>> Ribbon Editor is a fine tool, but doesn't get over the fact that
>> Word 2007 and 2003 are not the same.
>
> So if I have a 203 template called MyMacros.dot, and make sure the
> custom toolbars I use are attached to that template, then I can make
> this template an add-in in 2007 and the toolbars _should_ (fingers
> crossed!) be available in the Ribbon?
>
> Well, that's better than nothing. I'm glad the 2007 team at least
> threw us a bone. I'm a fairly light-weight "power user", but what I
> have I use constantly. I can only imagine what some have had to go
> through.
>
> Ed

Ed
Thu May 15 12:01:20 PDT 2008

Thank you, Graham. I really appreciate the boost!!

Ed


On May 15, 7:19=A0am, "Graham Mayor" <gma...@REMOVETHISmvps.org> wrote:
> Essentially yes - To ensure that the toolbar appears make sure that it is
> displayed and preferably 'floating' over the template document space befor=
e
> saving the template you intend to use in this manner.
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - =A0Word MVP
>
> My web sitewww.gmayor.com
> Word MVP web sitehttp://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
>
> Ed from AZ wrote:
> > On May 14, 10:44 pm, "Graham Mayor" <gma...@REMOVETHISmvps.org> wrote:
> >> You missed the point. There is no need to install Word 2003
> >> alongside 2007 to use custom toolbars that are already contained in
> >> 2003 document templates (Keeping a copy of 2003 for support would
> >> not be a bad plan however). They will appear on the add-ins tab. the
> >> Ribbon Editor is a fine tool, but doesn't get over the fact that
> >> Word 2007 and 2003 are not the same.
>
> > So if I have a 203 template called MyMacros.dot, and make sure the
> > custom toolbars I use are attached to that template, then I can make
> > this template an add-in in 2007 and the toolbars _should_ (fingers
> > crossed!) be available in the Ribbon?
>
> > Well, that's better than nothing. =A0I'm glad the 2007 team at least
> > threw us a bone. =A0I'm a fairly light-weight "power user", but what I
> > have I use constantly. =A0I can only imagine what some have had to go
> > through.
>
> > Ed- Hide quoted text -
>
> - Show quoted text -

Graham
Thu May 15 22:27:59 PDT 2008

You are welcome :)

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Ed from AZ wrote:
> Thank you, Graham. I really appreciate the boost!!
>
> Ed
>
>
> On May 15, 7:19 am, "Graham Mayor" <gma...@REMOVETHISmvps.org> wrote:
>> Essentially yes - To ensure that the toolbar appears make sure that
>> it is displayed and preferably 'floating' over the template document
>> space before saving the template you intend to use in this manner.
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web sitewww.gmayor.com
>> Word MVP web sitehttp://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>>
>> Ed from AZ wrote:
>>> On May 14, 10:44 pm, "Graham Mayor" <gma...@REMOVETHISmvps.org>
>>> wrote:
>>>> You missed the point. There is no need to install Word 2003
>>>> alongside 2007 to use custom toolbars that are already contained in
>>>> 2003 document templates (Keeping a copy of 2003 for support would
>>>> not be a bad plan however). They will appear on the add-ins tab.
>>>> the Ribbon Editor is a fine tool, but doesn't get over the fact
>>>> that Word 2007 and 2003 are not the same.
>>
>>> So if I have a 203 template called MyMacros.dot, and make sure the
>>> custom toolbars I use are attached to that template, then I can make
>>> this template an add-in in 2007 and the toolbars _should_ (fingers
>>> crossed!) be available in the Ribbon?
>>
>>> Well, that's better than nothing. I'm glad the 2007 team at least
>>> threw us a bone. I'm a fairly light-weight "power user", but what I
>>> have I use constantly. I can only imagine what some have had to go
>>> through.
>>
>>> Ed- Hide quoted text -
>>
>> - Show quoted text -

Jonathan
Fri May 16 01:33:51 PDT 2008

I use AutoText extensively, and my templates do work in Word 2007. It is
just that AutoText isn't so very visible from the user interface.

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup

"Graham Mayor" <gmayor@REMOVETHISmvps.org> wrote in message
news:e8JCFIntIHA.1328@TK2MSFTNGP03.phx.gbl...
> None of my macros that used Autotext ran in Word 2007 eg in Word 2003
> NormalTemplate.AutoTextEntries("AutoTextName").etc
>
> Word 2007 required
> NormalTemplate.BuildingBlockEntries("AutoTextName").etc
>
> I suspect the problem was something to do with the installation of 2007
> which when converting the entries may not have categorized the entries in
> the autotext gallery so the macro could not find them. I have retested and
> either will work as long as the entries are listed in the correct gallery.
>

> Unfortunately I can not easily go back to the original install condition
> to re-live exactly what the installation does with the autotexts from
> normal.dot. Suffice to say that I had to rework the macros that used
> autotext at the time, which irked somewhat :(.
>
> Shall we say that it *should* work? The learning curve for 2007 is steep
> enough, without this sort of detail ;)
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> Tony Jollans wrote:
>>> the notable exception being those that employ autotext, which will
>>> have to be modified.
>>
>> Is that true?
>>
>> I know, of course, that you can use Building blocks instead but I
>> thought old code would still run correctly.
>>
>>
>> "Graham Mayor" <gmayor@REMOVETHISmvps.org> wrote in message
>> news:O5NFw6ctIHA.552@TK2MSFTNGP06.phx.gbl...
>>> Ed from AZ wrote:
>>>> We just got the word - we will be "upgrading" to Office 2007
>>>> shortly. I _live_ by my macros! If they worked fine in Word 2000 and
>>>> 2003,
>>>> will they still work in 2007?
>>>
>>> Most of them should work, the notable exception being those that
>>> employ autotext, which will have to be modified.
>>>
>>>> I figure I need to make a backup of my Normal and templates. I know
>>>> the toolbars won't show up in 2007, and any macros that show or hide
>>>> toolbars on open or close won't work. If I clean these macros out
>>>> of my files, should everything else be mostly okay?
>>>
>>> The *custom* toolbars will show up in Word 2007 and you can show and
>>> hide those toolbars, though frankly there isn't a lot of point - see
>>> http://www.gmayor.com/Toolbars_in_word_2007.htm
>>>
>>> --
>>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>> Graham Mayor - Word MVP
>>>
>>> My web site www.gmayor.com
>>> Word MVP web site http://word.mvps.org
>>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>