Sherwood
01-18-2007, 04:41 PM
Hi,
I want to write an app in Excel VBA to record jobs where one person enters initial info like date, time, requirements, etc. (let's say the receptionist) and another person enters work done, parts used, time spent, completion, etc. (let's say the technician). Each has own PC on a network and there's a server PC. Each would have their Excel-VBA front end open all the time so it's 'read-only' for the other party. So how do I get data between them?
The solution obvious to me is to have a third workbook, sitting on the server, which each user's front end accesses briefly to upload/download data (open workbook, do the business, close the workbook), hence no read-only issue. Of course one front end could try to access it at same time that the other one is in there so I need to detect whether the workbook on the server is already open (then I'd program a short wait before trying again).
Q1. No doubt plenty of ways to skin this cat but am I approaching the whole concept in a suitable direction (one 'server' workbook and two 'client' workbooks)?
Q2. What sort of code would I use to detect workbook on server already open?
Sherwood.
I want to write an app in Excel VBA to record jobs where one person enters initial info like date, time, requirements, etc. (let's say the receptionist) and another person enters work done, parts used, time spent, completion, etc. (let's say the technician). Each has own PC on a network and there's a server PC. Each would have their Excel-VBA front end open all the time so it's 'read-only' for the other party. So how do I get data between them?
The solution obvious to me is to have a third workbook, sitting on the server, which each user's front end accesses briefly to upload/download data (open workbook, do the business, close the workbook), hence no read-only issue. Of course one front end could try to access it at same time that the other one is in there so I need to detect whether the workbook on the server is already open (then I'd program a short wait before trying again).
Q1. No doubt plenty of ways to skin this cat but am I approaching the whole concept in a suitable direction (one 'server' workbook and two 'client' workbooks)?
Q2. What sort of code would I use to detect workbook on server already open?
Sherwood.