How to automatically open a set of workbooks on startup

G

Guest

When I start up Excel, I always open a set of workbooks that are used
primarily as reference sheets. How can I create a macro or other technique to
open a specified set of workbooks on startup?
Or, after Excel starts up, then open a set of workbooks stored in different
locations.
 
G

Guest

Open the files you want to use and arrannge them on the screen then use
file>save workspace. To open all the files again just open the workspace
file and all the workbooks will open for you
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
G

Guest

Tools > Options> General > At startup open all the files in

and enter some folder

just cluster all the files in this folder
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unwanted workbooks on startup 2
Multiple instances of Excel (Multiple workbooks) 3
How to close all open workbooks in Excel 2007 1
2003 Keeps the default workbook open 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
MACRO TO COUNT ALL OPEN WORKBOOKS and print 1
Excel 2007 - Linking workbooks 1
Tips to speed up VBA with several workbooks open. 4

Top