thanks for your reply, onedaywhen.

The datagrid/webform solution is not an option. I already built
prototype using that model, however the customer was not happy with th
webforms usability.

my plan is to generate/validate the excel sheet using th
ThisWorkbook_Open() and ThisWorkbook_BeforeClose() events. It look
like that should be pretty straightforward.

My problem: How can users see the exisiting entries in the database?
This will be the starting point of the application. Users will see
list of exisiting entries, and from here, they can edit/delete entrie
or create new ones.

In the web prototype, I just provided a datagrid of existing records
and added hyperlinks to edit existing entries. How can I do the sam
in Excel. Should I build a windows form that displays a datagrid?
then launch excel to edit/add new entries?

or

Can I just show them a list of entries in an existing sheet?

Any help is appreciated.

Thanks,

-

--
Message posted from http://www.ExcelForum.com