Application.Tasks contains 16 tasks for 1 instance of Excel

[Angelos Petropoulos]

Hi,

We are using the property Application.Tasks in Word 2003 to try and find
all the open instances of Excel, so we can display them as a list for the
user to pick from when importing tables and charts. When the user selects
one of the instances, we use Task.Activate() to give focus to the open Excel
window.

This works fine, except in the case of one system (IBM T43 Thinkpad, WinXP
SP2, Word 2003 SP1), where for one instance of Excel open, there are 16 tasks
reported by Word.

Any suggestions or comments would be appreciated.


Regards,

Angelos Petropoulos

 

[zkid]

Using Application.Tasks returns an awful lot of superfluous stuff. You might
be better off figuring out which files are "in use" by determining whether or
not they are locked.

http://www.exceltip.com/st/Determine_if_a_file_is_in_use_using_VBA_in_Microsoft_Excel/444.html