Always Open a Specific Excel File

Do you work on a specific Excel file every day? Or you have a master file that must be opened every time you work in Excel? It is generally good idea to let Excel open up this file instead of manually opening every time as this will save little effort and time. Let’s see how?

When you open Excel, it will always open the files saved under a particular folder named XLStart. So, save any workbook as you normally save, in this folder. This folder can be found in one of the following locations depending on your operating system.

• Windows XP: C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLStart
• Windows Vista: C:\Users\<username>\AppData\Local\Microsoft\Excel\XLStart
• Windows 7: C:\Program Files\Microsoft Office\Office\XLStart

Once saved here, you will get this workbook opened every time you start a fresh instance of Excel.

Tip: To quickly know your start up file path, in VBA Immediate Window, type below line and press Enter.

? Application.StartupPath 

You may want to read about maintaining an alternate startup folder.