Re: How Do I - Click 'OK' in a dialog - Excel
Re: How Do I - Click 'OK' in a dialog - Excel
- Subject: Re: How Do I - Click 'OK' in a dialog - Excel
- From: Shane Stanley <email@hidden>
- Date: Wed, 08 Jun 2005 10:00:32 +1000
- Thread-topic: How Do I - Click 'OK' in a dialog - Excel
On 8/6/05 9:25 AM, "brian" <email@hidden> wrote:
> Thought this would be simple. Does Apple include a way to objectively control
> the UI What i want to do is delete a worksheet from an Excel workbook [see
> code below] problem I have is it pops up a dialog box and I do not know how to
> tell it OK, or to just do what i want without prompting.
It is simple, and you don't need to go near UI scripting:
tell application "Microsoft Excel"
set display alerts to false
tell active workbook to delete sheet "Deposits"
set display alerts to true
end tell
--
Shane Stanley <email@hidden>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden