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.
 
Ad

Advertisements

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)
 
Ad

Advertisements

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

Top