Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
standard data form direct to an excel spreadsheet
I want to be able to put in a persons name, address, postcode, social
security number etc in a row of an excel file. I must be able to do this over a network so many users can add to the spreadsheet. The program must also log the time that the data was added... any ideas on doing this? Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
standard data form direct to an excel spreadsheet
Scott,
with due respect, this is a job for a database, not a spreadsheet. If you are insistent on using a spreadsheet program like Excel then create a shared workbook and use a form to add data. Load the for from the Workbook_open event. OJ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
standard data form direct to an excel spreadsheet
You don't need a form, Excel has a built-in (DataForm...). All that is
needed is some event code to add the date when a line is changed. -- HTH RP (remove nothere from the email address if mailing direct) "OJ" wrote in message oups.com... Scott, with due respect, this is a job for a database, not a spreadsheet. If you are insistent on using a spreadsheet program like Excel then create a shared workbook and use a form to add data. Load the for from the Workbook_open event. OJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
transfer data from excel form to a spreadsheet | Excel Discussion (Misc queries) | |||
Can a standard data entry form be used to change formats of cells? | Excel Discussion (Misc queries) | |||
Replace/modify standard data form? | Excel Discussion (Misc queries) | |||
PASSING DATA FROM USER FORM TO EXCEL SPREADSHEET | Excel Programming |