Detecting when a process ends

  • Thread starter Thread starter kittronald
  • Start date Start date
K

kittronald

Does Excel provide a way to detect when a selection of formulas have
completed calculation or when a file save has completed ?

I want to run a macro, save the file, run another macro and save the
file again.

However, before each save, all formulas must have completed calculation.

Is this possible ?


- Ronald K.
 
    Does Excel provide a way to detect when a selection of formulas have
completed calculation or when a file save has completed ?

    I want to run a macro, save the file, run another macro and save the
file again.

    However, before each save, all formulas must have completed calculation.

    Is this possible ?

- Ronald K.
Click to expand...

sub runandsave()
macro1
activeworkbook.save
macro2
activeworkbook.save
end sub
 
The macro function
Calculate
forces a recalculation of all your fields. So you can build that in
to your sequence before you do your saves.
 
Don and Greg,

Thanks guys.

After setting up a combination macro, I see that the calculations
complete before the file save macro runs.



- Ronald K.
 
Back
Top