Office 97 to Office XP-Macros

[Dean]

Hello:

Will Excel 97 macros convert cleanly into Excel 2002? If
not, what should be done to ensure that the macros work in
Excel 2002? What errors should I expect? Thanks

Dean

 

[Chip Pearson]

Dean,

Generally speaking, VBA code written in Excel97 will work perfectly well
under later versions of Excel. No modification is necessary.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[J. Kunkel]

I was interested in this answer because I will soon be
using a new computer with Excel XP. When you change
computers, but want to save your macros, which file(s) do
you need to copy?

--Jan

 

[Dave Peterson]

Macros live in workbooks.

So you'll have to save all your workbooks that have macros. (I'd guess that
you'd want to save all your workbooks--with or without macros!)

But I'm guessing that you'll want to go out of your way to find your macros in
XLStart (usually named personal.xl*).

I have a short list of things to copy/update when we do this at work. It's far
from complete, but it gets most of the stuff.

Word/Excel files:

FileName Use
custom.dic personal dictionary
*.acl personal autocorrect list
mssp2_en.exc personal exclusion dictionary
normal.dot default (for new documents) template
*.dot Any other templates you've made

*.xlb personal toolbar (*see the note below)
book.xlt defaults for new workbooks
sheet.xlt defaults for new worksheets
personal.xl* personal macros
*.xlt Any other templates you've made

And don't forget any:
Local files (If you don’t store on LAN)
(Settings) Directories and other defaults


====
And if you're staying within the same version of xl (xl2002 for both pc's), I'd
copy over my *.xlb, too. (If you're upgrading, don't do this. Build your new
one from scratch and you'll see lots of new icons that have been made
available!)

And before you actually paste that *.xlb file, take a look at the filesize of
your current *.xlb file. I'd dump it if it's too large (>20k is usually already
pretty large).