Macro transfer

D

Dan Wilson

Good day. I just upgraded my Windws ME machine to XP.
I am still using Excel 2002. Prior to the upgrade, I
copied the entire C Drive to my D drive as I knew that I
would have to format the C Drive to load XP. Now that
all is back working, I need to know how to transfer the
macros that I had created under the Windows ME version to
the new folder in the XP version.

Thanks, Danno...
 
G

Gord Dibben

Dan

Macros can live in the workbooks in which they were created or in
Personal.xls.

You also could have placed the macros in a workbook and saved it as an
Add-in(*.xla)

If in Personal.xls, you must find that file and store it in your XLSTART
folder.

If in workbooks, just open those workbooks to access the macros.

If in an add-in, find it and load it through Tools>Add-ins.


Gord Dibben Excel MVP
 
D

Dan Wilson

Thanks Gord, I will give it a try.

Danno...
-----Original Message-----
Dan

Macros can live in the workbooks in which they were created or in
Personal.xls.

You also could have placed the macros in a workbook and saved it as an
Add-in(*.xla)

If in Personal.xls, you must find that file and store it in your XLSTART
folder.

If in workbooks, just open those workbooks to access the macros.

If in an add-in, find it and load it through Tools>Add- ins.


Gord Dibben Excel MVP
Click to expand...
 
Top