Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am planning to send a database to many users to input data (each one will
be a separate file, not a linked db). Most users do not have Microsoft Access installed on their computers, but all have Excel, so this will be an Excel file. I would like to have a User form to make data entry easy, but creating a complex User form in Excel is a lot more difficult than in Access (I don't want to write all the VBA code, and entry form is too complex for the the Data-Form function already in Excel). Is there a way that I can use Access to create a form and then import the form structure into Excel? Basically I want an Access front-end without a user having Access installed. Also, I want to do the data analysis in Excel. By the way, I have Access 2003 and Excel 2003. Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a 1pg form for each row of data in a spreadsheet? | Excel Discussion (Misc queries) | |||
How do I create a form template that will be sequential numbered | Excel Discussion (Misc queries) | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
how do i create an access code sheet to number my office files an. | New Users to Excel | |||
get access form in excel | Excel Discussion (Misc queries) |