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 ?
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
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?
 
Upvote 0
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 ....
 
Upvote 0
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 ?
 
Upvote 0

Forum statistics

Threads
1,214,936
Messages
6,122,340
Members
449,079
Latest member
rocketslinger

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top