VB to excel

[chandij]

Hi

I have been asked to create a front end where users will enter values and
then them values will be put into an excel sheet.
I am able to put values in excel. But the problem is that there are 15 users
and of course if one person is updating a worksheet then it is locked for the
others. Also the people I am doing this for dont have Microsoft Access on
there server.
I really need some tips on how to go about this.
I have been told to write the values to a '.csv' file. Will that make a
difference? Or how about XML? Can I store data with that and then move it
into excel?

I am only 19 years of age and I want to go about this the best way possible.

So I would really appreciate any input.

 

[Helmut Weber]

Hi,

first, you are in the wrong gropu.
This one is about programming Word.
Try microsoft.public.excel.programming.

In the meantime, in Excel,
have a look at "Tools, Share Workbook".

If you can prevent different users
from writing in the same Excel-range,
like
directing input from user A to rows 1 til 10,
directing input from user B to rows 11 til 20,
then it should be possible,
if your users are able to understand what's going on.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

 

[chandij]

Thank you