office:mac 2011 "SaveCopyAs Error 1004

[Mcmntb]

I've been using the following Mac Excel Office 2008 macro SUCCESSFULLY (for years):

Sub Autpen()
With ActiveWorkbook
.SaveCopyAs .FullName & ".Backup:" & Format(Now, "YYYY_MM_DD_HH_MM_SS")
End With
End Sub

to save a backup copy in the files' parent directory in a filename.backup folder with a date & time stamp.

Of course the backup folder exists.
Suddenly when going to Office:Mac Excel 2011 I get an error message as follows:

Run-time error '1004':
Method 'SaveCopyAs' of object '_Workbook' failed

This is a really big problem as ALL my Excel files have this. I would greatly appreciate any/all help!

 

[Domenic]

Does this help?

Sub Auto_Open()
    Dim FileName As String
    With ActiveWorkbook
        FileName = Left(.FullName, InStr(1, .FullName, ".xls") - 1)
        .SaveCopyAs FileName & ".Backup:" & Format(Now, "YYYY_MM_DD_HH_MM_SS")
    End With
End Sub

 

[Mcmntb]

I see where you were trying to go.
No-but it does create a new error on the FileName= line of:

Run-time error '5'.
Invalid procedure call or argument

I had already suppressed the extension as the filename. There is none, even hidden.

 

[Andrew Poulsom]

I think there may be a bug:

http://www.officeformac.com/ms/ProductForums/Excel/8089