Re: Applescript from Excel button
Re: Applescript from Excel button
- Subject: Re: Applescript from Excel button
- From: David Wignall <email@hidden>
- Date: Wed, 05 May 2004 19:13:27 +1200
on 5/05/2004 9:04 AM, Tom Bilski at email@hidden wrote:
>
I tried making a new macro to run the script, as suggested by David Wignal,
>
it still returns the error message. One thing that I noticed is that the
>
script starts, there is a dialog that appears at the beginning of the
>
Applescript, then I get the error message from Excel.
Any idea what the dialog says? Might be useful to post the script...
>
I realized another problem has developed and this one is easy to duplicate.
>
I have a script that closes an open Workbook with saving No.
>
>
tell application "Microsoft Excel"
>
Close Workbook "test" saving "No"
>
end tell
Shouldn't be any quotes around No, but you know that right? :-) Take those
off and it works fine OMM, same versions as you.
>
Since I9ve update to 10.3.3 I still get a dialog box that asks if I want to
>
save the document. I back rev9ed to Excel10.1.2 and the problem goes away.
>
But I still can9t run the separate and original script (which does not
>
include the save command.) The entire Applescript runs fine if it is double
>
clicked in the Finder window. When attaching the script to a button in
>
Excel and running the 3MacScirpt2 macro command Excel appears not to receive
>
the acknowledgment from the Applescript application... UGH!
>
>
Any other sugesstions?
Did you try encompassing the entire script in a try block? This would
prevent any AS error passing back to VBA and would indicate which one of the
two we should look at.
--
Dave
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.