Excel can automatically open files when it starts up. There are generally two folders that contain files that will be opened whenever Excel starts, but where they are depends on which version of Windows you have (and a few other factors).
The name of the first folder is XLSTART and can reside in a number of places.
- In Windows 98
- C:\Program Files\Microsoft Office\Office
- In Windows XP
- C:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLSTART
These are just two examples and don’t represent every place that your XLSTART could be. For instance, if you use Excel 2000 or above on a Windows 98 machine, you likely have a folder somewhere in “C:\Windows\Application Data…”
The combination of directories to XLSTART are seemingly endless considering all the factors that go into determining its location. Searching for “XLSTART” on your hard drive will give you a good idea of where they are. In VBA, you can check the StartUpPath property of the Application object which returns a string containing the path.
The second folder that contains files which will open automatically is one that you define. On the General tab under Tools>Options, there is textbox that lets you specify an alternate startup directory. That’s a bit confusing because it’s not really an alternate – Excel opens all the files in both XLSTART and the alternate startup directory, not one or the other. In Excel 2000, the dialog looks like this
You see that I have nothing specified in mine. Also note that in later versions, the textbox caption was changed to “At startup, open all files in:”.
If you find yourself in a situation where a lot of files are opening when you start Excel or files that are incompatible are opening, check your alternate startup directory. You may have files in there that don’t belong.