Here's the answer to last week's challenge on opening a specific workbook in Excel, along with a new question to test your Outlook skills.
- PiGuy314 reminded us that you can configure Excel to open all files in a specific directory by choosing Options from the Tools menu, clicking the General Tab, and specifying a directory using the At Startup Open All Files In option. Whether you store one or several workbooks in the directory, Excel will open them when you launch. Be careful when you choose this option as Excel will attempt to open all files, not just Excel workbooks. In addition, it'll cycle through any subfolders as well.
- Mihamil suggested saving workbook files in the XLSTART directory — another excellent solution.
- Mhbaum suggested using the Run command, which is a great tool that I forget about.