Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 9th 05, 07:27 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2005
Posts: 7
Default 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





  #2   Report Post  
Old September 12th 05, 11:25 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2004
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return Information from Shell Command Andibevan[_4_] Excel Programming 6 September 7th 05 12:33 PM
SHELL to open an application and pass parameters to it jwkz Excel Programming 3 August 12th 05 09:41 PM
Shell can open an application, can it close an app too? quartz[_2_] Excel Programming 4 April 26th 05 03:30 PM
shell out of excel into another app toothfish__[_2_] Excel Programming 0 January 19th 04 04:02 PM
Application Process-Shell Command GarethG[_10_] Excel Programming 2 October 29th 03 02:35 PM


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017