How to automatically open a set of workbooks on startup

A

ACad2KMan

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

John

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

Gary''s Student

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

Turning off automatic calculation 0
Need Help with Macro Security 1
Unwanted workbooks on startup 2
Get rid of Microsoft AutoUpdate 0
2003 Keeps the default workbook open 1
selecting workbook/sheet 3
Start up workbook 2
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1

Top