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.

 

[alansidman]

Option Explicit

Sub ListWorkbooks()
    Dim wb As Workbook
    Dim ws As Worksheet
    Dim i As Single, j As Single
    Set ws = Sheets.Add
    For j = 1 To Workbooks.Count
        Range("A1").Cells(j, 1) = Workbooks(j).Name
        For i = 1 To Workbooks(j).Sheets.Count
            Range("A1").Cells(j, i + 1) = Workbooks(j).Sheets(i).Name
        Next i
    Next j
End Sub

 

[mehidy1437]

Thanks for your help, it just give me the details of excel file details.
Actually I'm looking for others file details also.

Like I have one PDF, JPG & DOC opened currently, but it don't give me the details of those file.
Is it possible to get the details of those file in excel cell or not?

 

[mehidy1437]

Can anyone else advise please?

 

[mehidy1437]

Is this not possible?

 

[Macropod]

Cross-posted at: Get a list of all open files in non-Office applications

Please read Mr Excel's policy on Cross-Posting in rule 13: Message Board Rules

 

[lrobbo314]

Try this.

 

[mehidy1437]

Try this.

Hi thanks for the info.
It's almost similar as this, but I just looking for the file details with their path , not the applications details.

 

[Jaafar Tribak]

Hi mehidy1437

There is a small program written in C that you can download and use to get the list of all opened files .

In the meantime, I am trying to write a similar code in VBA and if something interesting comes up, I'll post it here.

 

[mehidy1437]

Hi mehidy1437

There is a small program written in C that you can download and use to get the list of all opened files .

In the meantime, I am trying to write a similar code in VBA and if something interesting comes up, I'll post it here.

Many thanks, i will wait for the VBA code.
I don't know, how to use c.