Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |