Workbooks(). close intermittent failure

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

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