Revision history [back]

You can switch from one opened Excel application to another using VBA by using the Application.Activate method.

Here is an example of VBA code to switch to another open Excel application:

Sub SwitchToExcelApp()

    ' Activate the Excel application with the specified name
    Application.Activate "Excel Filename"

End Sub

Replace "Excel Filename" with the filename of the Excel application that you want to switch to.