Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Jan 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    List and Activate excel files

    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

  • #2
    Senior Coder Mhtml's Avatar
    Join Date
    Jun 2002
    Location
    Sydney, Australia
    Posts
    3,531
    Thanks
    0
    Thanked 1 Time in 1 Post
    What language?
    Omnis mico antequam dominus Spookster!

  • #3
    New to the CF scene
    Join Date
    Jan 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sorry, VB6

  • #4
    Senior Coder Mhtml's Avatar
    Join Date
    Jun 2002
    Location
    Sydney, Australia
    Posts
    3,531
    Thanks
    0
    Thanked 1 Time in 1 Post
    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.
    Omnis mico antequam dominus Spookster!


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •