(Main Question Answered) Check File Open with random Path

The code you posted,

    Filename = "test.xls"
     FileExists = False

     For Each book In Workbooks
         If UCase(book.Name) = Filename Then

... can never succeed because it's comparing an uppercase word to a lowercase one.

I obviously wasn't even paying attention, Thank you for pointing this out to me, I was so obsessed with the file being open, I didn't even see what was plain before me.