View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default 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-