View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wes_A[_2_] Wes_A[_2_] is offline
external usenet poster
 
Posts: 37
Default Opening / Closing files using Excel Macro?

Excel 2007 on XP Pro:
I am trying to write a a macro in Excel which will:
(1) open a workbook from another only if not already open
(2) close the workbook from another only if the other workbook is already
open.
Any ideas?