Ask Your Question
1

How can you switch from one opened Excel application to another using VBA?

asked 2022-08-18 11:00:00 +0000

pufferfish gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2022-01-27 15:00:00 +0000

ladyg gravatar image

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.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2022-08-18 11:00:00 +0000

Seen: 18 times

Last updated: Jan 27 '22