Application.AltStartupPath Property (Excel)
Returns or sets the name of the alternate startup folder. Read/write String.
Syntax
expression .AltStartupPath
expression A variable that represents an Application object.
Example
This example sets the alternate startup folder.
Application.AltStartupPath = "C:\EXCEL\MACROS"