Trapping an open Workbook

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Hi, I am putting together a kind of Client server app
using Excel, I will have a simple spreadhseet using an
ODBC call to get information from a central sheet, but I
also want to allow the Client to write data back to the
central sheet, I think the only way I can do this is by
opening up the central sheet, running a loop to find the
record and writing data to it. But if someone else has it
open then it will crash, is there a way to error trap the
fact the central sheet is open and wait 10 seconds and
try again ? or is there a better way to write data back
to a central sheet that will have a number of poeple
using it ?
 
Excel should take care of this automatically on opening, providing th
workbook is not set up for sharing, by forcing it to become Read Onl
if someone else is using it. You can then do a check with somethin
like :-

'-----------------------------------------
If ActiveWorkbook.ReadOnly = True Then
MsgBox ("Someone else is using this workbook. Please try agai
later.")
End
End If
'-----------------------------------------
 
Back
Top