minusbfold Posted September 18, 2006 Share Posted September 18, 2006 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 Link to comment Share on other sites More sharing options...
hazard_abio Posted September 18, 2006 Share Posted September 18, 2006 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.ThanksThe macros in excel are actually stored within the Excel file itself. so as long as the Excel files are backed up they will be tooany 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" Link to comment Share on other sites More sharing options...
P51D Mustang Posted September 18, 2006 Share Posted September 18, 2006 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now