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.
Asked: 2022-08-18 11:00:00 +0000
Seen: 18 times
Last updated: Jan 27 '22