If it is constantly the same app you're switching to you can use the
AppActivate statement.
For example:

appactivate "Microsoft Word"
appactivate thisworkbook.name (to switch back)


"Excelerate-nl" wrote in message
...
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