View Single Post
 
Old 09-29-2023, 03:21 AM
MartinGM MartinGM is offline Windows 11 Office 2021
Competent Performer
 
Join Date: May 2023
Location: England
Posts: 101
MartinGM is on a distinguished road
Default Close file or quit application ?

I would like to create a macro which works as below but I can't quite see how to do it . . .
  • If another Excel workbook is not open, save the active workbook, close it and quit Excel
  • If another Excel workbook is open, save the active workbook and close it - leaving the other workbook(s) open.
I know how to do all of this, except how to detect if another Excel workbook is open.
Thanks for any help
Reply With Quote