I don't think you can do that from excel, as Excel can only control an
instance of an application that it has created itself. If you want to
control already-open applications, you would need to write a Windows
Application.
"Excelerate-nl" wrote:

Dear JM,

I only would like to switch to an already open application that I would also
get when I use the Alt-tab key command.

Regards,

Jan Bart

"SeaparkJohn" wrote:

You can use the Create.Object command from Excel to open another application
such as Word, e.g.

Dim oApp As Object
Set oApp = CreateObject("Word.Application")
Set oDoc = oApp.documents.New
oApp.Visible = True


JM


"Excelerate-nl" wrote:

I making an application in Excel that copies the content of a range to any
other running application on the computer, as can be done by a manual
copy/paste action.
However I want to automate the alt-tab key command (for switching to the
former application). What is the propriate VBA code for this action?

Thanks in advance,

Jan Bart