Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Opened applications

Hello,

Would it be possible to list all the opened applications/windows that a user
sees in the taskbar?
I know how to list the running processes, but two windows can have the same
process.

Thank you in advance for any suggestion.
Regards


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 117
Default Opened applications

Patrick,

You can use "Tasks" if you open an instance of MS Word. The example below
is a bare bones approach; you would probably want to check if Word is
already open etc. but this will give you a start. The 'Name' property of a
given task is the friendly name (title bar type name) rather than the
process name (which is often different).

'------------------------------------------

Sub ListVisibleWindows()
Set objWord = CreateObject("Word.Application")
For Each myTask In objWord.Tasks
If myTask.Visible Then
MsgBox myTask.Name
End If
Next myTask
objWord.Quit
Set objWord = Nothing
End Sub
'------------------------------------------

Steve Yandl

"Patrick" wrote in message
...
Hello,

Would it be possible to list all the opened applications/windows that a
user sees in the taskbar?
I know how to list the running processes, but two windows can have the
same process.

Thank you in advance for any suggestion.
Regards

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
restricting other applications from being opened when running a macro [email protected] Excel Programming 0 September 28th 07 09:40 PM
stop excel file opened as read only if already opened by another u bobm Excel Programming 3 August 5th 05 04:11 PM
Opening a workbook if not opened, going to it if already opened neotokyo[_2_] Excel Programming 1 September 24th 04 07:17 PM
Opening a workbook if not opened, going to it if already opened neotokyo Excel Programming 1 September 24th 04 06:33 PM
How to see if the opened workbook is opened by another user ? balexis Excel Programming 1 August 18th 04 04:11 PM


All times are GMT +1. The time now is 02:38 AM.

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

About Us

"It's about Microsoft Excel"