Opening workbooks in sequence

M

Matt

Hi All

I have a group of workbooks, each with a routine in the Auto_Open event. Upon opening the routine is executed and the workbook is saved (Using Workbooks("....").Close, True)

I have written a routine in a seperate parent workbook to take care of opening these in sequence. I have discovered that if you do not save the child workbooks then everything runs OK. However, if you exit the child workbooks and save them, the routine in the parent workbook halts. Is there a way around this

Thanks
Matt
 
B

Bob Phillips

Matt,

A bit confused as to whether you are opening or closing. Is it the closing
that is failing because they have already been saved? If so, you could try
something like

On Error Resume Next
Set oWB = Workbooks("file1.xls")
If Not oWB Is Nothing Then
Workbooks("file1.xls").Close ,True
End If
'etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Matt said:
Hi All,

I have a group of workbooks, each with a routine in the Auto_Open event.
Click to expand...
Upon opening the routine is executed and the workbook is saved (Using
Workbooks("....").Close, True)
I have written a routine in a seperate parent workbook to take care of
Click to expand...
opening these in sequence. I have discovered that if you do not save the
child workbooks then everything runs OK. However, if you exit the child
workbooks and save them, the routine in the parent workbook halts. Is there
a way around this?
 
M

Matt

Sorry (That confused me too when I read it back

I have a main workbook and it has a routine which opens other workbooks in sequence

Workbooks.open("Workbook1"
Workbooks.Open("Workbook2")

et

In the Open event of each of these workbooks is a routine. If you don't put code to close/save these workbooks at the end of the routine then each workbook opens OK. If you place code to close and save the workbooks at the end of the routine then the routine in the main book doesn't go any further.

Thanks
Matt
 
B

Bob Phillips

Hi Matt,

I see what you mean now. When the called WB closes, the code thread is lost
with it, so the original code does not continue. Don't think there is much
you can do about that other move the code that is in the child workbooks
from the Workbook_Open event to an Auto_Open macro because Auto_open doesn't
fire when a workbook is opened from code.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Matt said:
Sorry (That confused me too when I read it back)

I have a main workbook and it has a routine which opens other workbooks in sequence.

Workbooks.open("Workbook1")
Workbooks.Open("Workbook2")

etc

In the Open event of each of these workbooks is a routine. If you don't
Click to expand...
put code to close/save these workbooks at the end of the routine then each
workbook opens OK. If you place code to close and save the workbooks at the
end of the routine then the routine in the main book doesn't go any further.
 
Top