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

Discussion in 'Windows 7 Help and Support' started by Trainer, Mar 16, 2009.

  1. Trainer

    Trainer New Member

    Joined:
    Mar 16, 2009
    Messages:
    2
    Likes Received:
    0
    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
     
    #1 Trainer, Mar 16, 2009
    Last edited: Mar 16, 2009
  2. russdude

    russdude New Member

    Joined:
    Aug 14, 2011
    Messages:
    2
    Likes Received:
    0
    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.
     

Share This Page

Loading...