Re: Execution Error with Excel script
Re: Execution Error with Excel script
- Subject: Re: Execution Error with Excel script
- From: Shane Stanley <email@hidden>
- Date: Fri, 09 Nov 2001 09:07:49 +1100
On 9/11/01 4:38 AM +1000, Rebecca Felts, email@hidden, wrote:
>
I have the script below which saves the active workbook. If a file of that
>
same name already exists, excel asks if user wants to replace it. If the
>
user answers "Yes", this script executes fine and returns true. However, if
>
the user answers "No" or "Cancel", the script throws an Execution Error:
>
"Microsoft Excel got an error: Unable to get the SaveAs property of the
>
Workbook class". Can I force the save and not let excel ask?
One of the confusing things with Excel's dictionary is that some classes
appear more than once. If you scroll down the Custom Suite, you'll find a
second entry for "application", which includes the boolean parameter
"AlertBeforeOverwriting", and another called "DisplayAlerts". Either should
solve your problem.
--
Shane Stanley, email@hidden