Hello All,

I have a procedure that take a several days to run. In the vent there is
an interruption in the electricity supply I have to start all over.
I have tried setting the variable to "static", which I was hopping wpuld
hold the values of the variables and start from where it left off. This
does not appear to work. Can anyone offer some insight?

Regards
Dk

*** Sent via Developersdex http://www.developersdex.com ***

"Derick Hughes" wrote in message
...
Hello All,

I have a procedure that take a several days to run. In the vent there is
an interruption in the electricity supply I have to start all over.
I have tried setting the variable to "static", which I was hopping wpuld
hold the values of the variables and start from where it left off. This
does not appear to work. Can anyone offer some insight?

Regards
Dk

*** Sent via Developersdex http://www.developersdex.com ***

Off the cuff, I'd create a sheet("placeholder"), break the macro into
numerous sub-routines with each saving the neccessary variables to seperate
lines on the placeholder. When the macro starts, determine the last
subroutine previously processed, load its saved variables then call the
routines from there-on.

any computer crashes when you pull the plug.
running variables are GONE unless persisted to harddisk.

I've never tired it.. but I assume that if the computer goes in standby
e.g. on battery low for a laptop.. it should resume when the computer
gets a wakeup.


SO.. you can hook up a UPS to the PC so it has time to suspend itself...
http://www.apcc.com/products/


keeps me wondering how to write code that takes days to execute...
you must be an engineer or scientist :)


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Derick Hughes wrote :

Hello All,

I have a procedure that take a several days to run. In the vent there
is an interruption in the electricity supply I have to start all over.
I have tried setting the variable to "static", which I was hopping
wpuld hold the values of the variables and start from where it left
off. This does not appear to work. Can anyone offer some insight?

Regards
Dk

*** Sent via Developersdex http://www.developersdex.com ***