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

Question

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

prudge (Mechanical)

(OP)

27 Oct 10 17:40

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 (Structural) · Answer 1 · 2010-10-27 17:58:33

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 (Electrical) · Answer 2 · 2010-10-27 22:18:58

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)' ?

Come Join Us!

Posting Guidelines

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