View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mischa Browne Mischa Browne is offline
external usenet poster
 
Posts: 1
Default Closing workbooks

Hi



Struggling with the following problem.



Is it possible to close two workbooks working with VBA?



I have tried following codes:



Application.DisplayAlerts = False 'step 1
Windows("Book1.xls").Close 'step 2

Windows("Book2.xls").Close 'step 3
Application.DisplayAlerts = True 'step 4





Problem is, macro stops running after step 2!







Thanks,

Mischa