After making changes to an existing excel workbook I try to use the workbook invoke close and I receive error "Error 1004 occurred at Exception occured in Microsoft Excel, Close method of Workbook class failed". How can I save the changes to workbook without receiving this error.
Be sure you close all references before closing the workbook, except workbook and application, and check where the error is born wiring the error cluster. Sometimes errors are carried from a earlier step, avoiding correct execution. Hope this helps
