Excel VBA Program to Close All Running Excel Programs and Open the Current Excel

Intro to Excel VBA - Writing VBA Code Pt. 1 - YouTube

The problem is if you close all the open Excel files, the one with your VBA code will also close. You can try doing it from Access VBA.

Here's some code to loop through your open workbooks in Excel VBA:

Sub Macro1()

Dim appExcel As Excel.Application

Dim wb As Workbook

'Set application object

Set appExcel = Application

'Loop through open excel workbooks

For Each wb In appExcel.Workbooks

'print workbook name

debug.print wb.name

Next wb

End Sub