Thread: Which PC has workbook open?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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/



Reply With QuoteReply With Quote