ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Return to Excel after shell an application (https://www.excelbanter.com/excel-programming/339583-return-excel-after-shell-application.html)

abc[_6_] September 9th 05 07:27 AM

Return to Excel after shell an application
 
Dear all,

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?

Thanks in advance





Stephen Bullen[_4_] September 12th 05 11:25 AM

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




All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com