View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mason Mason is offline
external usenet poster
 
Posts: 3
Default Code to close workbook

I have code that opens an excel file. Can I have an Open event on the new
opened Excel file that closes the original file?

So workbookA code opens workbookB. The open event in workbookB closes
workbookA.
But I won't know the name of workbookA, and other workbooks may be open also
and we don't want them closed.