AltStartupPath Property
From Microsoft Excel Visual Basic
AltStartupPath Property
Returns or sets the name of the alternate startup folder. Read/write String.
Example
This example sets the alternate startup folder.
Application.AltStartupPath = "C:\EXCEL\MACROS"