Starting Inputbox focused?
Lance,
See if this does it...
AppActivate "Microsoft Excel"
Regards,
Jim Cone
San Francisco, CA
"Lance Hoffmeyer" wrote in message ...
I am running scripts from SPSS to manipulate Excel
worksheets. At one point I am running a macro in
Excel that brings up an Inputbox
Since I am running from SPSS the Inputbox is not focused
when it opens and I have to hit ALT-TAB to bring it into
focus. Is there a way to have it automatically open
focused?
Sub CreateExcel()
Set objExcelApp = GetObject(,"Excel.Application")
objExcelApp.Visible = True
objExcelApp.Run "addnewsheetifneeded"
End Sub
-snip-
|