How to automatically open a set of workbooks on startup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ACad2KMan - 28 Mar 2007 01:00 GMT

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.

Signature

Philip Anderson

Reply to this Message

John - 28 Mar 2007 10:18 GMT

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

Signature

John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

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

Reply to this Message

Gary''s Student - 28 Mar 2007 13:54 GMT

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

and enter some folder

just cluster all the files in this folder

Signature

Gary''s Student
gsnu200712

Reply to this Message