新聞財經娛樂♬資訊 News Economy

The following changes the default file type when saving in Excel:
Application.DefaultSaveFormat = xlOpenXMLWorkbookMacroEnabled

Does anyone know if this works in Mac 2011 as well?  If not, what would be a comparable code?

I am unable to test in a Mac at this time.

Thanks.

Probably, it is okay using xlOpenXMLWorkbookMacroEnabled but if
using number 52 to specifiy ,xlOpenXMLWorkbookMacroEnabled ,
for example, ActiveWorkbook.SaveAs "C: est.xlsm", fileformat:=52
that might not work unless you add 1 on 52 equal to 53
You can take a look at this article in which show all compatibility at the bottom.
http://www.solveyourtech.com/change-the-default-file-format-in-excel-2011-for-mac/

Hope understand your question. If not, please point it out

Duncan