View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Returning the focus to Excel

If you mean you want bring Excel to the front and activate, and with
whatever was previously active in Excel -

Appactivate application.caption

Regards,
Peter T


"Tom Joseph" wrote in message
...
I am running a series of VBA processes, then publishing/saving some PDFs
and
finally emailing the PDFs. The code should then run aonther series of
processes. It seems to stall because Excel has lost the focus.

How to I return the focus to Excel or the workbook?

Thanks.