Advise user if workbook open, who is the 'owner' and option to try again

Hi,

I'm trying to adapt some code to check if a file is already open (get the name of the 'owner' and pass it back) and give the user the option to try again. I plan to create a small userform with a label caption and a button to try again - "... goto tryagain"

However, I'm failing at the first hurdle as I get a runtime error 450 on GetSecurityDescriptor in the function.

I've probably done something stupid, but can't see it - maybe because it's a Friday afternoon and I'm a bit tired...

Code in sub:

Please Login or Register  to view this content.

Code in function:

Please Login or Register  to view this content.

Anyone spot the obvious mistake?!

Thanks, TC

Please Login or Register  to view this content.

Hi all,

Thanks for coming back on this.

Solus - yes the TempPTPath dies contain the full file path and name (confirmed in imediate window) and still failed with the edit suggested - think it was my Function coding letting it all down.

Kenneth - thanks for this yes that worked perfectly - obviously something wrong in my function coding which I tried to keep simple but just ended up breaking instead.

Thanks again, TC.