I have some code that helps me identify when a shared network file is open, causing me to be unable to open and write to it:

Please Login or Register  to view this content.
The If Not statement launches this Function:

Please Login or Register  to view this content.
This is kinda cool, but it's not all that HELPFUL. What I'd like, instead of it just exiting, I'd like to set something up like the "Notify" function built in to Excel, that will notify the person running this when the file is open again. I'd like it to e-mail them when the file is open again. I don't need help on the "writing the email" part, but I have no idea whether or not it's possible to do the lock-check thing.

Any ideas?