VBA Excel - Get Filename of every Excel SS across multiple instances

[prudge]

I need to get the filenames of all currently open workbooks in all instances of Excel. As well as change the focus to any open workbook in any of those instances.

I have tried almost everything and searched everywhere, but still have no solution.

For Each process In GetObject("winmgmts:{impersonationLevel=impersonate}").InstancesOf("Win32_process ")
If process.Name = "EXCEL.EXE" Then
activateapp(process)

This is about the closest I could find.

Any help would be great.
Thanks

 

[MiketheEngineer]

You might post this over at Tek-tips.com - a sister to this website. Those guys are real programming geeks and know some stuff.

 

[electricpete]

This will get all the workbook names in the current excel:
Sub getwbs()
Dim mywb As Workbook
For Each mywb In Workbooks
Debug.Print mywb.Name
Next mywb
End Sub

I agree Tek-tips is a good bet.

=====================================
(2B)+(2B)' ?