XLSB Way back in my Windows XP days, it lived here: C: Documents and Settings Application Data Microsoft Excel XLSTART PERSONAL. creating personal macro workbook excel 2016Ĭreating personal macro workbook excel 2016, creating a personal macro workbook in excel, creating a personal macro workbook in excel 2010, macro for creating new excel workbook, excel macro create worksheet, excel macro create worksheets from list, excel macro create workbook, excel macro create worksheet with name, excel macro create workbook with name, excel macro create worksheets based cell values, excel macro create workflow, excel create personal macro workbook, excel macro create new workbook with name, excel macro create new worksheet Whatsapp For Iphone On Mac In the immediate window, type?Application.If the immediate window is not visible, press ctrl+command+g to make it so.XLSB)” Finding the Path The best way to find the path–hat tip to commenter Kevin Woodward–is to use the Visual Basic Editor (VBE). Once you create it, your Personal Macro Workbook will be listed in the VBA Editor as “VBAProject (PERSONAL. creating a personal macro workbook in excel 2010.
Where it lives, though, is a moving target On my install of Windows 10, running Excel 2016, it lives here: C: Users wheatbread Roaming Microsoft Excel XLSTART PERSONAL.
