XL Start folder in Excel 2013

In previous versions of Excel, I stored my macros in the XLStart folder under the C: Microsoft Office: Office location. I cannot find this folder in Excel 2013. Where do I look for this folder or where do I save my macros?
Answer
Answer

As a general method of locating it:

Alt+F11 to the visual basic editor
Ctrl+G to the immediate window

Type
?Application.StartupPath
and press Enter will give you the personal XLSTART and

Type
?Application.Path

and press Enter will give you the Excel folder to which you add \XLSTART for the all-users XLSTART.


Ahhh.   Thank you!  I forgot about that.  This explains a small issue I was having.  This should fix it.

 

Windows "search" couldn't fid it, and the only one I found by manual search was this:

 

?Application.Path
C:\Program Files\Microsoft Office 15\root\office15

?Application.StartupPath 

gave me the same location you mentioned.    Never thought to look in the "Roaming" folder.  :>~

 

Thanks again.  :>)

 

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer
In previous versions of Excel, I stored my macros in the XLStart folder under the C: Microsoft Office: Office location. I cannot find this folder in Excel 2013. Where do I look for this folder or where do I save my macros?


Hi. I've been experimenting with this same issue.

 

Mine is located here with Windows 8 and Office 2013.

 

C:\Program Files\Microsoft Office 15\root\office15\xlstart

 

Took me a while to find it also.  :>~

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated July 2, 2022 Views 33,264 Applies to: