MS Access VBA How to I supress the "Do you want to save changes" dialog for excel row deletes? -
similar question in ms access vba how delete row in excel
however, problem excel asks "do want save changes made ...?" there way force saving of changes , disable message box? try docmd.setwarnings false, not work.
you'll need add following code thisworkbook
private sub workbook_beforeclose(cancel boolean) thisworkbook.save end sub
if you're running vba in access , accessing excel object, save workbook (e.g. xlapp.thisworkbook.save
) in code before closing
Comments
Post a Comment