Toggling on/off auto calc

[Secret Squirrel]

How can I toggle on and off the automatic calculations in VBA code? I have a
code that imports data from another file but when I run this code I want to
be able to shut off the auto-calc until the import is done. How would I do
this?

 

[Jim Rech]

Try recording a macro as you perform the action manually. That's a good way
to start learning the Excel object model.

--
Jim
message | How can I toggle on and off the automatic calculations in VBA code? I have
a
| code that imports data from another file but when I run this code I want
to
| be able to shut off the auto-calc until the import is done. How would I do
| this?

 

[Gord Dibben]

Sub todostuff()

Application.Calculation = xlManual
your code here
Application.Calculation = xlAutomatic

End Sub

 

[Secret Squirrel]

Thanks! That works for me!

 

[Jim Rech]

If you give a man a fish you feed him for one day. If you teach him to fish
you feed him for a lifetime.

--
Jim
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
| Sub todostuff()
|
| Application.Calculation = xlManual
| your code here
| Application.Calculation = xlAutomatic
|
| End Sub
|
| On Tue, 20 May 2008 07:20:01 -0700, Secret Squirrel
|
| >How can I toggle on and off the automatic calculations in VBA code? I
have a
| >code that imports data from another file but when I run this code I want
to
| >be able to shut off the auto-calc until the import is done. How would I
do
| >this?
|

 

[Gord Dibben]

Along with Excel help we are now dispensing homilies?<g>

But......point taken Jim


Gord