ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Displaying File in Use By Info with vba (https://www.excelbanter.com/excel-programming/298644-displaying-file-use-info-vba.html)

s0mistr

Displaying File in Use By Info with vba
 
Hi

Do you know how to get the information to display who's using the file but only using vba

Thanks in Advanc

Shai

Harald Staff

Displaying File in Use By Info with vba
 
Hi Shai

Open it by code and read the WriteReservedBy property of the file. This may
or may not work, depending on "how the network is built", I haven't found
better explanations on this.

HTH. Best wishes Harald

"s0mistr" skrev i melding
...
Hi,

Do you know how to get the information to display who's using the file but

only using vba.

Thanks in Advance

Shai





All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com