Macros can live in any workbook or add-in.

Yours were probably in a file named Personal.xls which is stored in your XLSTART
folder usually found at...................

C:\Documents and Settings\username\Application Data\Microsoft\Excel

You would copy that file from old HDD and paste into the XLSTART folder on new
computer.


Gord Dibben MS Excel MVP

On Tue, 27 Nov 2007 14:44:02 -0800, FL wrote:

How do I locate the file which stores Excel Macros? My PC hard drive was
removed and placed as a secondary drive into another PC. I'm now using a new
PC that has Excel but not my original custom macros. I need to locate and
copy the file which stored the macros that I used that are on the old hard
drive. Can this be done? What is the file name that I need to locate and
what path does it need to be stored in?