none
Excel macro run time error 1004 Method 'save' of object '_workbook' failed

    Question

  • I have an annoying problem. I have a macro enabled excel spreadsheet that performs some functions when the spreadsheet is initially opened (with Auto_Open) and then saves the file with the command

    ActiveWorkbook.Save

    Most of the time it works correctly but ocasionally I will this error: run time error 1004 Method 'save' of object '_workbook' failed ". When I debug it, it bombs on the line where it is trying to save the file. If I save the file manually and then run the auto_open macro again it works fine. This makes no sense to me. 

    Has anyone else experienced this issue?

    I am using Excel 2013.

    Thanks.  

    Thursday, November 07, 2013 9:01 PM

All replies

  • Hi,

    Since the reason could be many, could you mind to provide sample code to help us to reproduce?

    Friday, November 08, 2013 8:56 AM