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
|