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?

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

--
Jim
"Secret Squirrel" wrote in
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?

Sub todostuff()

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

End Sub

On Tue, 20 May 2008 07:20:01 -0700, Secret Squirrel
wrote:

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?

Thanks! That works for me!

"Jim Rech" wrote:

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

--
Jim
"Secret Squirrel" wrote in
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?

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
| wrote:
|
| 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?
|

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

But......point taken Jim


Gord

On Tue, 20 May 2008 11:45:07 -0400, "Jim Rech" wrote:

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.