list open workbooks in multiple open excel applications

[wbl]

Hi,

I'am trying to get list of all open workbooks in multiple running excel applications in EXCEL VBA.

I'am trying a lot of solutions, but they only works with the active excel application.

Is there someone who can give me a fabulous solution ?

 

[johnwm]

Hi wbl and welcome to Tek-Tips

May I suggest you read faq222-2244. You may then find that forum68 or forum707 may provide better answers for specifically VBA questions

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[paulbent]

You may be able to use EnumWindows and EnumChildWindows. Given you know the the class name of a workbook window, the workbook name will be part of its title text.

There's a free utility, WinSpy, on my website that shows the properties of open windows.

http://www.northwindit.co.uk/pages/WinSpy.htm

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[paulbent]

Oops, forgot to post the link to an EnumWindows example:

http://support.microsoft.com/support/kb/articles/q183/0/09.asp

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[Bowers74]

Got to Forum707 for VBA programming issues:

This procedure will help you out though (in Excel VBA):

Sub ListOpenWorkbooks()
Dim msg As String, wb As Workbook
For Each wb In Application.Workbooks
    msg = msg & wb.Name & vbLf
Next wb
MsgBox msg, , "Open Workbooks"
End Sub

Peace!!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884