Re: Excel Problems
Re: Excel Problems
- Subject: Re: Excel Problems
- From: Larry McMunn <email@hidden>
- Date: Thu, 9 Nov 2000 13:55:06 -0500
Try this:
tell application "Excel"
activate
set DisplayAlerts to false
--do your stuff here
set DisplayAlerts to true
end
You might also want to use:
set screenUpdating to false (true)
This turns off (on) screen updating. scripts run faster without updating the display.
If you don't turn either of these back on in the script, you will need to restart Excel to set them back to normal-- so be careful.
Good Scripting! :-)
Larry McMunn
President
McMunn Associates, Inc.
Specialists in automated Data Visualization thru Apple products
Collingswood, NJ
(856) 858-3440
---------------------------------------------------------------