Re: how to disable save prompt on closing excel file in automated mode

Tech-Archive recommends: Speed Up your PC by fixing your registry

If I want to close another workbook in VBA, I'd use something like:

workbooks("otherworkbook.xls").close savechanges:=false

(false means I want to discard those changes.)



vipag@xxxxxxxxx wrote:
>
> how to disable "Do you want to save the changes to <file name>" manual prompt
> everytime while closing excel files having macros (macro password not known),
> while in automated task mode which is closing and opening files automatically.

--

Dave Peterson
.