Detecting when a process ends

[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.

 

[Don Guillett]

    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.

sub runandsave()
macro1
activeworkbook.save
macro2
activeworkbook.save
end sub

 

[Greg Glynn]

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.

 

[kittronald]

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.