ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Which PC has workbook open? (https://www.excelbanter.com/excel-programming/307647-pc-has-workbook-open.html)

ianripping[_92_]

Which PC has workbook open?
 
Is there a way of finding out which Networked PC is using a cerai
workbook usgin VBA

--
Message posted from http://www.ExcelForum.com


Tom Ogilvy

Which PC has workbook open?
 
Some say this doesn't work for them, but open the workbook Readonly and then
check

workbooks("workbookinquestion.xls").WriteReservedB y

--
Regards,
Tom Ogilvy



"ianripping " wrote in message
...
Is there a way of finding out which Networked PC is using a cerain
workbook usgin VBA?


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 10:53 PM.

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