we used following code in excel 2007 disable file save prompt:
private sub workbook_beforeclose(cancel boolean) thisworkbook.saved = true end sub after upgrading excel 2010 code no longer works. have researched , tried of following code no luck:
private sub auto_close() thisworkbook.saved = true end sub application.displayalerts = false private sub workbook_beforesave(byval saveasui boolean, cancel boolean) cancel = true application.displayalerts = false end sub application.enableevents = false application.displayalerts = false if wasopened2 workbooks(filenamenopath(foundfiles(i))).close false application.displayalerts = true application.enableevents = true any other ideas appreciated.
Comments
Post a Comment