Thread-topic: How Do I - Click 'OK' in a dialog - Excel
User-agent: Microsoft-Entourage/10.1.0.2418
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:
http://lists.apple.com/mailman/options/applescript-users/email@hidden
This email sent to email@hidden
