[minusbfold]

I work for an IT dept and im rebuilding a users computer and I want to copy off the old pc the macro's she uses but i cant figure out where those files if there is any reside.. Can someone help me on how to copy a macro from one pc to another.

Thanks

[hazard_abio]

minusbfold, on Sep 18 2006, 01:48 PM, said:

I work for an IT dept and im rebuilding a users computer and I want to copy off the old pc the macro's she uses but i cant figure out where those files if there is any reside.. Can someone help me on how to copy a macro from one pc to another.

Thanks

The macros in excel are actually stored within the Excel file itself.

so as long as the Excel files are backed up they will be too

any default workbooks that run at startup will be under
"C:\Program Files\Microsoft Office\OFFICE11\XLSTART\"
or
"C:\Documents and Settings\user_name\Application Data\Microsoft\Templates"

[P51D Mustang]

VBA may be stored in the workbook itself.

Another location is the Personal Macro Workbook, a hidden workbook named "personal.xls" (saved in the XLStart directory at "C:\Program Files\Microsoft Office\OFFICE11\XLSTART").

A third option is to set up the workbook with the data in one workbook that references code in another workbook, sorta like a split database.