Excel - open several workbooks at the same time

I would like to repeatly open the same workbooks at the same time just
by selecting just one book and the other three or four will open with
it.

thanks  everyone

Use this simple event code, just remember to insert it into the
codesheet ThisWorkbook in the first workbook you open.

Private Sub Workbook_Open()
Workbooks.Open ("Book2.xls") ' Change as required
Workbooks.Open ("Book3.xls")
Workbooks.Open ("Book4.xls")
End Sub

Regards,
Per

See help on saving a set of files as a workspace.

Basics are.............open your 3 or 4 workbooks.

View>Save Workspace.

Default name is resume...........extension .xlw

Give your workspace whatever name you like and save.

I will use  mywkspace

Now close all workbooks.

Open mywkspace.xlw  and all books will open.


Gord Dibben  MS Excel MVP

Hi

cant get it to work ?  is the "codesheet" the same as a macro ?

johnnyboy

Thanks kind of works,  but I would like each workbook (4 of them) to
appear as tabs at the bottom)

oh I am using Excel 2003

No, the "codesheet" is not the same as a macro. A macro is placed in a
Module (Insert/Module from the VB editor's menu bar) whereas event code
(which is what the Workbook_Open procedure is) goes on a "codesheet"... in
this case, the codesheet for the workbook (because it is **workbook** event
code). When in the VB editor, look at the Project Window (it is the one with
Sheet1, Sheet1 and other stuff in it). Do you see the entry marked
ThisWorkbook? Double click it. That should have opened up the codesheet for
the workbook... copy/paste the Workbook_Open code procedure into it. Next,
save your workbook. That's it... next time you open the workbook, the
Workbook_Open code you just copy/pasted should run (assuming you have
enabled macros to run, that is).

--
Rick (MVP - Excel)

2003 version.

With the workbooks open.  File>Save Workspace.

To see the workbooks on the Taskbar....Tools>Options>View>Windows in
Taskbar.


Gord


just

t

Thanks

John

On 5 June, 21:22, "Rick Rothstein"
n
nt
ith
or
,
st
h

Thnaks Rick - Think I have got it now,  one last question how do I
keep the "main" workbook open and the others are open but as tabs at
the bottom,  just right now the last workbook in the list that is
opened is the one that is presented in Excel and the others including
the "main sheet" are open as Tabs.

Many thanks for your time.  Johhny

in
vent
with
for
xt,
.
just
ith

Hi

just sorted it,  I added the "main" sheets name to the bottom of the
workbook list and it goes there after the others have also loaded

work like a dream... many thanks

Johnny

On 5 June, 21:22, "Rick Rothstein"
n
nt
ith
or
,
st
h

HI

just pluged in my pen stick into my works PC and it wont open the
files - coz the file drive at work is called e.g  F:   at home its
called  G:

so the workbooks dont get found unless I manually change the drive in
the code text

hope this makes sense.

example  Workbooks.Open ("F:\Direct Payments DOT\0.5 yearly payment
planner.xls")

Johhny