Hi,
Thanks for the reply, I appreciate you taking the time!

I tried the code you posted, and the msgbox always says "File is not open" regardless if the file is actually open or not.




I'm simply trying to get the macro to check and see if - ThisWorkbook.Path & "\Signed Agreement.pdf" - is currently open or not.

If it is open, it'd be cool if it could close it (no need to save), but a msgbox stating it's open works too.
If it's not open, then do nothing.

The code in my first post is what I found googling, and it works fine as long as the file path is embedded in the code; which won't work for this purpose.