Excel 2011 VBA problem

[LTL1963]

This works in Excel 2010, but not 2011.
This is a daily cost report that gets updated every day, the file makes a back-up before it posts/totals for any revisions.
In 2011 is saves to the wrong folder and wrong file name, file becomes foldername/DCR.xlsm or DCR/DCRBAK.xlsm.

This worked perfect in Excel 2003, then I had to add the new files extensions .xlsm for 2010 & 2011. I need it to work on a minimum of 2010 & 2011. It would be great if it still worked in 2003. Multiple people will use this with different versions of Excel.

2011 only like the .xlsm with macros or wants to strip out the macros.
I tried .xlsb, that wouldn't work.

Sub Save_After_Post()
    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "/" & "DCR.xlsm", FileFormat:= _
        xlOpenXMLWorkbookMacroEnabled, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
        , CreateBackup:=False
End Sub
Sub Save_Before_Post()
    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "/" & "DCRBAK.xlsm", FileFormat:= _
        xlOpenXMLWorkbookMacroEnabled, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
        , CreateBackup:=False
End Sub

 

[Smitty]

If you look at RonDebruin's Send Activesheet page, he's got some code that addresses saving workbooks with code in different versions.

HTH,

 

[LTL1963]

I did try adding some of the VBA from his article and even contacted him, his response was "Sorry I don't have a Mac?"

So the problem still exists, it's difficult for me since I'm new to Mac but the company pushed me into it to test it out. I have limited back ground and no support in a very small office.

Maybe I'm approaching the question the wrong way but not sure how to ask it.

 

[Smitty]

Sorry, I won't be any help to you with a MAC either, but there are a few MAC users on the board.

 

[LTL1963]

Smitty, Thank-you anyway.
Hopefully a Mac user will help...