VBA Code to check if a folder window is open?

Why would it be open?

Doesnt that mean you are trying to OPEN a file?

Are you talking about a windows explorer folder is open or a folder is open in the Excel open file prompt thing?

I understand what you WANT to do I just dont follow WHY you want to do it. I wouldnt want to automate or handle EVERY possible snonsensical thing a user could do OUTSIDE of excel using VBA IN excel, that just sounds like a futile path...

Yeah, absolutely but my point is you might be trying to squeeeeze lemon out of a brick. You are asking for help on how you can control windows explorer with VBA, then how you can validate if a particular folder is open IN windows explorer, which is outside the typical Excel objects, properties and methods. That gets exponentially more complicated but have a look through google, it is outside my little VBA experience.

http://vbadud.blogspot.com/2009/01/h...using-vba.html
http://stackoverflow.com/questions/1...-select-a-file

Seems to be the most closely related to what I could find quickly:
http://stackoverflow.com/questions/1...er-is-open-vba


Good Luck.

Thanks for the links. I've been googling like crazy as well, but hadn't come across that last link for some reason; odd. At any rate, the last code on that link will work for what I need it to do. Here is a copy of the code. I just need to change the "OpenFold" and "strFolder" to reference cell values, have it call a function, and I should be all set.

Sub test1()
        Dim OpenFold As Variant
        Dim oShell As Object
        Dim Wnd As Object
        Dim strFolder

        OpenFold = "mysubfolder"
        strFolder = "U:\myfolder\" & OpenFold
        Set oShell = CreateObject("Shell.Application")

        For Each Wnd In oShell.Windows
            If Wnd.Name = "Windows Explorer" Then
               If Wnd.Document.Folder.Self.Path = strFolder Then Msgbox "The folder is open"
            End If
        Next Wnd
End Sub

Thanks for the assistance!