VBA SaveAs FileFormat 53???

[Myriad_Rocker]

So I have this Excel thing...well, we'll call it thing. It's rather large so I don't want to go into details but nevertheless, I have a SaveAs routine that will not work in Excel 2007 when saving with file format 52 for .xlsm. Excel 2010 will open it but Excel 2007 will not. It says the file is corrupt.

Just so we're all on the same page, I'm talking about the file that got saved.

So...if I change that to FileFormat 53, it works. But my question is, why? Everything I have found on the interwebs says to use 52!

 

[Scott Huish]

According to the VBA help file in 2010:

53 is for an Open XML Template Macro Enabled
52 is for an Open XML Workbook Macro Enabled

What happens if you just use the named constant?
xlOpenXMLWorkbookMacroEnabled

 

[Myriad_Rocker]

According to the VBA help file in 2010:

53 is for an Open XML Template Macro Enabled
52 is for an Open XML Workbook Macro Enabled

What happens if you just use the named constant?
xlOpenXMLWorkbookMacroEnabled

I can't do that because different versions of Excel are used across our customer base.

I could check the Excel version before going into it, though, I suppose.