UNDONE changes made by using the open source data base PALO

**ssauerw** · 02-11-2007, 08:11 PM

Hi *,

I'm using the open source server PALO (www.palo.net) as the data base backend to my excel application. Unfortunately, data inputs to PALO cannot be undone by the built-in excel function.

Some background informations:
I'm using a Palo add-in in my spreadsheets. This gives me the opportunity to type in a special function like this:

=PALO.DATAC(parameters)

Now, the cell that contains this formula shows the actual value of the the data base record specified by the parameters. If the user wants to change this particular value, (s)he only has to type in the new value. The PALO formula is still intact but the data value in the data base is updated.

PALO is a great product but unfortunately, users don't have the option to undone their data input. I'm not very familiar with Excel VBA but maybe someone has an idea how to solve this problem...

Regards,
Steve

**Bryan Hessey** · 02-12-2007, 07:27 AM

Originally Posted by ssauerw

Hi *,

I'm using the open source server PALO (www.palo.net) as the data base backend to my excel application. Unfortunately, data inputs to PALO cannot be undone by the built-in excel function.

Some background informations:
I'm using a Palo add-in in my spreadsheets. This gives me the opportunity to type in a special function like this:

=PALO.DATAC(parameters)

Now, the cell that contains this formula shows the actual value of the the data base record specified by the parameters. If the user wants to change this particular value, (s)he only has to type in the new value. The PALO formula is still intact but the data value in the data base is updated.

PALO is a great product but unfortunately, users don't have the option to undone their data input. I'm not very familiar with Excel VBA but maybe someone has an idea how to solve this problem...

Regards,
Steve

Hi,

perhaps something simple like a Workbook Close event which took a copy of the worksheet (paste Special = Values) to another sheet which could be referenced for the required 'Undo' value.

This would, of course, not be a true undo, but might suffice for your needs.

Alternately some more elaborate VB code could capture each change requested, immediately Undo, copy the cell to the backup sheet, ReDo, and apply the requested change, giving a better 'Undo' option. A simple Shortcut-key macro could then restore the currently selected cell from the backup sheet.

hth
---