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

[Trainer]

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

 

[russdude]

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.