Need the name of an application !!!!

autigers

Board Regular
Joined
Oct 9, 2005
Messages
139
I have a program which when viewed in task manager is called "WMS21"
however, when I right click the name and choose go to process, it says its called "exceed.exe" ....
How can I get the name of the App so that I can use an AppActivate ?
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

GaryAtWork

Board Regular
Joined
Dec 19, 2005
Messages
83
Copied from the vba help file.....

AppActivate Statement Example
This example illustrates various uses of the AppActivate statement to activate an application window. The Shell statements assume the applications are in the paths specified. On the Macintosh, the default drive name is "HD" and portions of the pathname are separated by colons instead of backslashes.

Dim MyAppID, ReturnValue
AppActivate "Microsoft Word" ' Activate Microsoft
' Word.

' AppActivate can also use the return value of the Shell function.
MyAppID = Shell("C:\WORD\WINWORD.EXE", 1) ' Run Microsoft Word.
AppActivate MyAppID ' Activate Microsoft
' Word.

' You can also use the return value of the Shell function.
ReturnValue = Shell("c:\EXCEL\EXCEL.EXE",1) ' Run Microsoft Excel.
AppActivate ReturnValue ' Activate Microsoft
' Excel.

So if you know the path of the application, could you use the second example above and then check the value of MyAppID?
 

autigers

Board Regular
Joined
Oct 9, 2005
Messages
139
I tried that .... did'nt work. The code failed at AppActivate TaskId
" Error 5 - Invalid procedure call or argument"

Okay heres what runs ....

Code:
Sub Test()
Dim MyApp, TaskId

MyApp = ("C:\Documents and Settings\All Users\Desktop\WMS Lancaster.exe")
TaskId = Shell(MyApp)
Application.Wait (Now + TimeValue("0:00:15"))
AppActivate TaskId

End Sub

When this file is executed it does the following
Open > C:\WNNT\sys.32\cmd.exe, C:program~1\openssh\bin\ssh.exe
then it connects to program via a program called "exceed" to
167_140_195_227:00.0

When the app opens its name is "WMS21"
but when I try and make it do anything, it errors .....

I can open the program, but I can't activate it ....
 

autigers

Board Regular
Joined
Oct 9, 2005
Messages
139
okay .. messing around with it for a while now and heres where I'm at ..

AppActivate ("WMS")
works only when the program is not in a minimized state.

Any suggestions ?
 

Watch MrExcel Video

Forum statistics

Threads
1,119,264
Messages
5,577,081
Members
412,763
Latest member
sienweiw
Top