View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan[_18_] Alan[_18_] is offline
external usenet poster
 
Posts: 4
Default 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.