vba xla 与 xlam 插件，有什么区别？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13071185/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
xla vs xlam addin, what is the difference?
提问by mezamorphic
Could someone please explain the difference between an xla Excel addin format and an xlam Excel addin format? Googling didnt provide anything useful.
有人可以解释一下 xla Excel 插件格式和 xlam Excel 插件格式之间的区别吗？谷歌搜索没有提供任何有用的东西。
采纳答案by Trace
The m stands for macro-enabled which is the new format (as from Excel 2007).
These are add-ins that may call macro's.
On the other hand, you could also have xlax extensions, which are meant for macro-freeworkbooks.
m 代表启用宏的新格式（从 Excel 2007 开始）。
这些是可以调用宏的加载项。另一方面，您也可以有 xlax 扩展名，用于宏自由工作簿。
Note also the difference between xls and xlsm, where xlsx files also don't contain macro's.
还要注意 xls 和 xlsm 之间的区别，其中 xlsx 文件也不包含宏。
Why? My guess is that the main reason would be security.
Some people don't like to receive files, not knowing if there are potentially harmful macro's in it. In the old format, you could not make the distinction based on the file extension.
为什么？我的猜测是主要原因是安全性。
有些人不喜欢接收文件，不知道里面是否有潜在有害的宏。在旧格式中，您无法根据文件扩展名进行区分。
回答by Mickey Perlstein
Both files are macro enabled files:
这两个文件都是启用宏的文件：
- XLA files are excel files for office 97 - that are loaded as addins
- XLAM files are excel 2003+ files, which are actually zip files that have xml documents inside them per opendocument protocol.
- XLA 文件是 Office 97 的 Excel 文件 - 作为插件加载
- XLAM 文件是 excel 2003+ 文件，它们实际上是 zip 文件，其中包含每个 opendocument 协议的 xml 文档。
