Excel to VB

[Chandij]

Hi

I have a simple spreadsheet that needs to be updated by more than 10 people
Simultaneously. But this is not possible as the spreadsheet becomes locked
when one person has it open.

My first idea was to create a front end with a Microsoft database to store
all records. But they do not have Microsft Access on their server.
Now I am thinking of creating a vb front end application. This will include
a few input boxes and an update command button which, will update the excel
sheet with the latest data.

I am 19 and new to programming. I really need to know what is the best way
to go about this and few tips on how to code it.

Many thanks

 

[Jezebel]

Have them each email their data to one person, who uploads it all into the
spreadsheet.

 

[Chandij]

Thats exactly what I would say. At max there are about 10 records added a day.
So it should not be any problem. But I have to do my job and that is to do
what I am asked.

 

[Jezebel]

Creating a VB front-end application doesn't solve the problem: you still
can't have the spreadsheet open by more than one user at a time. Your VB app
could use an Access-type database (your users don't need Access for this);
but for 10 records a day, this is getting absurd.

Perhaps you're too young to know how to do this, but part of your
responsibility as a programmer is to say 'no' when the specification just
doesn't make sense.