Search code examples
vbaexcelxla

How to find path to XLA file in Microsoft Visual Basic for Applications 7

When I open Microsoft Visual Basic for Applications 7, I see the project window. I.e. file1.xla, file2.xlam, etc. If I have multiple files names file1.xla, how do I know which one I'm looking at? I can't find the path to the file in the IDE.

I have some Excel plugins installed, which might be why some files continuously show up in the list.

Solution

  • In the Immediate Window, you can type:

    ?Workbooks("File1.xla").path

    for example.