Hello,
sorry that I didn't expressed myself in a better way.
What I'm trying to do is to replace all formulas used on a certain
worksheet (eg. worksheet "A") with their current values on a certain
day in the future.

The macro should do something like this:

by opening the worksheet, check the date
if it's eg. 01.04.2005, then go to worksheet "A",
select all cells,
copy,
past values
save
if it's not the 01.04.2005 yet, then do nothing.


the date will be determined by myself and typed into the macro.


The whole procedure is just to limit the period in which the
spreadsheet will work.

It's like an evaluation software which won't work anymore after a
certain period of days.

Thanks,
Norbert


On Mon, 31 Jan 2005 23:41:03 -0800, "Patrick Molloy"
wrote:

You haven't explained fully...are you saying that you know where the data for
a given date is stored?
It sounds like you've actually LOST the data for a given date & are looking
to recover it. Fraid not. IF you're working for a company and IF you save
down your work to a network share, and IF your IT do backups every night then
they might be able to restore a workbook from a given date.

"Orion" wrote:

Hi everybody,

is there a way to run a command at a certain date?
E.g.: Delete all formulas of worksheet "A" and replace them by the
cells value on the 01.04.2005 10:00am.

Any help is very much appreciated.

Thanks
Norbert