Get the list of all open file in vba

[mehidy1437]

Hi guys,

How to get the list of all open file in excel using VBA? Which are currently open.
Open file can be any file, it can be image, dox, pdf, xlsx, ai etc.

 

[Jaafar Tribak]

Many thanks for your kind help.

You are welcome sir.

Its give me the details. after some times.
Its slow may be for my machine.

It could be ... In my home PC, the search (6 diffrent file extensions) took about 3 mins whereas in my work pc, the same exact code took only 85 seconds. Big difference !