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.

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.

Ok. mmm, haven't done that. Any quick tutorials?



Tom Ogilvy wrote:
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.

Existing code to write data
range("A1").Value = Userform1.Textbox1.Text


Now add additional functionality

to retrieve date
Userform1.Textbox1.Text

after it is edited
range("A1").Value = Userform1.Textbox1.Text


obviously, there is more involved, but with no details, this should give you
the idea.

--
Regards,
Tom Ogilvy



wrote in message
ups.com...
Ok. mmm, haven't done that. Any quick tutorials?



Tom Ogilvy wrote:
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.

Thank you.

I also see that you have written a number of responses about this
subject. A search of 'editing userform data' brought out a number of
informational responses.

I need to digest all of this information but it looks very capable of
being done in excel.

Thank you,

Tom Ogilvy wrote:
Existing code to write data
range("A1").Value = Userform1.Textbox1.Text


Now add additional functionality

to retrieve date
Userform1.Textbox1.Text

after it is edited
range("A1").Value = Userform1.Textbox1.Text


obviously, there is more involved, but with no details, this should give you
the idea.

--
Regards,
Tom Ogilvy



wrote in message
ups.com...
Ok. mmm, haven't done that. Any quick tutorials?



Tom Ogilvy wrote:
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.

to retrieve date
Userform1.Textbox1.Text

should have been

to retrieve date
Userform1.Textbox1.Text = Range("A1").Value

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
Existing code to write data
range("A1").Value = Userform1.Textbox1.Text


Now add additional functionality

to retrieve date
Userform1.Textbox1.Text

after it is edited
range("A1").Value = Userform1.Textbox1.Text


obviously, there is more involved, but with no details, this should give
you the idea.

--
Regards,
Tom Ogilvy



wrote in message
ups.com...
Ok. mmm, haven't done that. Any quick tutorials?



Tom Ogilvy wrote:
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.