View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SeaparkJohn SeaparkJohn is offline
external usenet poster
 
Posts: 2
Default VBA code to switch to other application

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