how do I convert personal macros from 2003 to 2007

[ashforma]

I have an investment in personal macros in Word 2003 and need them in 2007,
Word didn't convert them, how do I do this?

This also applies to Excel 2003 and Excel 2007

 

[Jay Freedman]

Go to Office button > Word Options > Customize. In the Category
dropdown, select "Commands not in Ribbon". Find the Organizer item in
the list and click the Add button to put it on the Quick Access
Toolbar (QAT). Close the options dialog.

Click the Organizer button on the QAT. In the dialog, go to the Macro
Project Items tab. One side of the dialog shows your Normal.dotm
template. On the other side, which initially shows the current
document, click the Close File button. When that button changes to
Open File, click it again; select the template (probably Normal.dot)
that contains your macros.

The list that appears shows the names of modules in the template, not
individual macros. Select some or all of them, and click the Copy
button to copy them into Normal.dotm.

Most Word 2003 macros will work properly in Word 2007. There are a few
typical trouble spots, though: macros that work with CommandBars or
with AutoText (which is now part of the Building Blocks feature), and
macros that automatically add ".doc" or ".dot" extensions to partial
filenames.

I don't know what you need for Excel 2007. I suggest you ask that in
the Excel programming newsgroup.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

 

[ashforma]

Thanks Jay, I will give it a try.

Mark

Go to Office button > Word Options > Customize. In the Category
dropdown, select "Commands not in Ribbon". Find the Organizer item in
the list and click the Add button to put it on the Quick Access
Toolbar (QAT). Close the options dialog.

Click the Organizer button on the QAT. In the dialog, go to the Macro
Project Items tab. One side of the dialog shows your Normal.dotm
template. On the other side, which initially shows the current
document, click the Close File button. When that button changes to
Open File, click it again; select the template (probably Normal.dot)
that contains your macros.

The list that appears shows the names of modules in the template, not
individual macros. Select some or all of them, and click the Copy
button to copy them into Normal.dotm.

Most Word 2003 macros will work properly in Word 2007. There are a few
typical trouble spots, though: macros that work with CommandBars or
with AutoText (which is now part of the Building Blocks feature), and
macros that automatically add ".doc" or ".dot" extensions to partial
filenames.

I don't know what you need for Excel 2007. I suggest you ask that in
the Excel programming newsgroup.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.