If you used a userform to allow the user to enter data, then pulling up
existing data, allowing the user to edit it and writing it back should be
trivial.
If you formatted a worksheet for this purpose, again, adding code for the
additional functionality should be very easy.
--
Regards,
Tom Ogilvy
wrote in message
oups.com...
Hello,
I have an application that I wrote in excel. It has 80 fields that I
wrote a front end just to put data into the excel spread sheet. Now,
the customer would like to view and change records thru the front end.
I am not sure to go about this using excel. But I believe that using a
db tool like MSaccess would allow the functionality that the customer
requires. But the customer is unwilling to invest in the project -
there in lies the rub.
Is there a tool out there that is freeware that will allow me to import
what I have built (GUI front and/or data from the excel sheet.) But
will allow for the reports (like access) based on the tables?
Or is there a way to write the change and review functionality in
excel?
Any advice would be appreciated.