WriteReservedBy displaying my name even though I am read only

[Steve@Rugby]

Hi,

Can anyone please advise me if it is possible to check who has WriteReservedBy on an excel workbook using vba in a different workbook. I currently have the code below which is only returning my name no matter who has the file open read/write.

Please Login or Register  to view this content.

The file i am checking is on a shared network drive and when opening manually you do get the user name for current user with WriteReservedBy, so I assume this is not anytype of network issue?

My objective is to open workbook "testfile" using vba within workbook "RigLog" if workbook "testfile" is open read only then return a message indicating which user has WriteReservedBy.

Regards
Steve

[shg]

Is WriteReserved True?

[Steve@Rugby]

Hi shg,

Yes, made sure of this by asking another colleague to open the file whilst I tested it.

Regards
Steve

[Izandol]

WriteReservedBy property will return name of the user that saved the workbook with password to modify. It will not return name of the user that has workbook open for editing.

[Steve@Rugby]

Hi Izandol,

Thanks for your reply, yes I just found some information on internet also confirming your answer. I will leave this thread open in the hope someone may have an idea that will work for me.

Regards
Steve

[Izandol]

You may try reading the lock file owner:

Please Login or Register  to view this content.

[Steve@Rugby]

Hi Izandol,

Thanks, how do i call these functions? Sorry not too familiar with them

Regards
Steve

[Izandol]

You may use:

Please Login or Register  to view this content.

[Steve@Rugby]

Hi Izandol,

Excellent that works as needed, thank you.

Regards
Steve

[Izandol]

You are welcome.