View Full Version : List and Activate excel files

01-24-2005, 10:04 AM
Still struggling !!????!!

How do list the Active Excel Applications in a list box AND then activate one specific one?

If there are 3 different open excel files, a list box must show these names, so that the user can select and activate “set focus” to that one specific excel file.

Any code will be highly appreciated.

Thanx in advance

01-25-2005, 03:00 AM
What language?

01-25-2005, 07:25 AM
Sorry, VB6

01-25-2005, 08:33 AM
Ok well the idea is the same no matter the language.
Basically you need a list of all running processes, then you eliminate which ones are not excel processes and then you need to get the information for each of those processes.

Just load the EnumerateProcesses from the PSAPI.dll library.