View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stephen Bullen[_4_] Stephen Bullen[_4_] is offline
external usenet poster
 
Posts: 205
Default Return to Excel after shell an application

Hi Abc,

I write a macro to email a list of files by outlook express through shell.
As focus passes to OE and it finish the email sending process, the focus
remain on OE. How can the focus pass back to the worksheet?


Use:

AppActivate Me.Caption

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev