moving excel2002 macros to 2003

D

depleted

We're moving a user to a new workstation. Her old setup was wit
Office2002. We're concerned about how to ensure that her numerou
Excel2002 macros are saved and available on her new computer runnin
Excel2003.

thank yo
 
D

Dave Peterson

I wouldn't be surprised if all your macros worked without any changes.

But the only way you'll know for sure is either by testing in xl2003 or by going
live and waiting for complaints.
 
G

Gord Dibben

Depends upon where the macros are saved.

If in Personal.xls, move that file.

If in workbooks, just move the workbooks.

Gord Dibben Excel MVP
 
D

depleted

I moved all the .xlb files into application data/microsoft/excel and th
buttons show up in the toolbar but are broken.

"the file could not be accessed, try on of the following"

There was no personal.xl
 
D

depleted

btw... I'm testing this by moving the files to another Excel200
install. The 2003 move can come after I prove at least one step
 
D

Dave Peterson

It sounds like those buttons had macros assigned to them. And those macros
lived in workbooks that didn't get moved. So you'll have to move the workbooks
that contain the macros. And you'll have to move them to the same
location--same drive, same folder on the new pc.

Or reassign the buttons to the workbooks in their new location.
 
Top