ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to make a running XL app the active desktop window using VBAcode. (https://www.excelbanter.com/excel-programming/271134-re-how-make-running-xl-app-active-desktop-window-using-vbacode.html)

Dave Peterson[_3_]

How to make a running XL app the active desktop window using VBAcode.
 
Something like this will cause the icon to flash in the windows start bar:

Option Explicit
Sub testme()
Application.Wait Now + TimeSerial(0, 0, 5)
AppActivate Application.Caption
End Sub



SVLewis wrote:

I run an xl97 wb receiving a real-time data feed. I also run 2 other apps at
same time. I need a way to make the XL app become the active window on the
desktop using VBA code.


--

Dave Peterson



All times are GMT +1. The time now is 10:55 PM.

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