View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Steen Steen is offline
external usenet poster
 
Posts: 104
Default share workbook/sheet

Hi again Dave

Thanks again for your answer - dispite the fact that it was exacty what I
was a afraid off - I don't know any thing of databases...

What about using the Share function in Excell - any expirence with that?

/Steen

"Dave Peterson" skrev:

Nope.

But if you want concurrent users, you may find that excel is not the application
for you. Maybe using a real database program (Access??) would be a better fit.

Steen wrote:

Hi Dave

Thanks for your answer.

I have not tried the hints yet, but will the use of forms help in the
ability to have concurrent users accessing the excelsheet?

/Steen

"Dave Peterson" skrev:

You could use some built-in features of excel that may work ok.

In xl2003 and below, you can use Data|Form.
(try it on some test data)

And if that isn't enough, John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

And if that's not sufficient, then maybe you could design your own input
userform.

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Steen wrote:

Hi

I have a team of 8 people using a task list for daily opdate of status, work
done, estimation to complete, etc.. The wordbook uses several sheets and
macros.

What I would like was if it where possible to make a little application that
made i possible to select a specific row(s) an update specific field (fx in a
form). Wood that be possible? Could it be working just using "share wordbook"?

/Steen

--

Dave Peterson


--

Dave Peterson