Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trapping an open Workbook
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trapping an open Workbook
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 '----------------------------------------- -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) |