Workbooks(). close intermittent failure
 

My Excel application requires frequent and rapid openings
& closures of other workbooks. "Workbooks(ThatBook).Close
savechanges:= True" succeeds when called within one
procedure, but fails when called within another. Opening
and closing is usually done within
an "Application.Screenupdating = True / False" shell.
The anomaly is the same if I use "Windows(ThatBook).Close"

Any advice would be appreciated.

Workbooks(). close intermittent failure
 

the only reason I could see that failing is if
thatbook does not contain the name of an open workbook (may be a
scoping/visibility problem)

Regards,
Tom Ogilvy


Alan wrote in message
...
My Excel application requires frequent and rapid openings
& closures of other workbooks. "Workbooks(ThatBook).Close
savechanges:= True" succeeds when called within one
procedure, but fails when called within another. Opening
and closing is usually done within
an "Application.Screenupdating = True / False" shell.
The anomaly is the same if I use "Windows(ThatBook).Close"

Any advice would be appreciated.