I have an auto_open macro which saves file as a csv, then closes the application. The file is opened using Task Scheduler every night. Until recently this worked fine, but now when it runs it shows save changes prompt and fails to close Excel. I've not changed the macro so at a loss to know why this no longer works or how to fix. many thanks.
Please Login or Register to view this content.