[dba-Tech] Excel VBA -- don't save

Susan Harkins ssharkins at gmail.com
Fri Sep 3 17:58:28 CDT 2010


Dan, I was just running this through and you're right -- I wasn't calling it 
correctly.

I'll take a look at DoCmd.Quit -- might be much easier than what I was 
trying to do!

Thanks!
Susan H.


> Hi Susan,
>
> I this that this command only closes the workbook, and that you need 
> another
> command to close Excel.
>
> How about DoCmd.Quit?
> I'm using the procedure included below in an Excel worksheet, to keep 
> Excel
> from saving any changes -- when the user clicks Close, I want Excel to 
> close
> without saving changes and without asking if the user wants to save 
> changes.
> This doesn't seem to work.
>
> Sub CloseActiveWBNoSave()
>  'Close the active workbook without saving.
>  ActiveWorkbook.Close False
> End Sub
>
> Any help?
>
> Susan H.
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com 




More information about the dba-Tech mailing list