Does anyone know where the excel marco's are stored?

#1
Excel macro's: Does anyone know where the excel marco's are stored?

Before installing Windows 7 I exported the macro's I use in Excel (Office 2007) and made a copy of the Personal.xlsb file. In Vista, the Personal.xlsb is stored at C:\Users\user name\AppData\Local\Microsoft\Excel\XLSTART. I have imported the macros into visual basic but I can only save them into that particular workbook and when I reopen Excel, the macros are not avaliable. Any suggestions?
thanks
 


Last edited:
#2
Re: Excel macro's: Does anyone know where the excel marco's are stored?

I find the Excel personal.xlsb file lives in C:\Users\yourlocalusername\AppData\Roaming\Microsoft\Excel\XLSTART on my W7 machine. Hope that helps someone save some time.
 


This website is not affiliated, owned, or endorsed by Microsoft Corporation. It is a member of the Microsoft Partner Program.
Top