Re: 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


.