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
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.