Shulou(Shulou.com)06/02 Report--

This article mainly introduces what xlsm refers to, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Xlsm is an OFFICE2007 format file, and XLSX files are also excel2007 files, but xlsm files contain macros enabled; Excel does not execute macro XLSX files, even if they contain macro code, so files containing macros can be saved as xlsm files.

The .xlsm file is in OFFICE2007 format. Add macro code to the EXCEL2007 file, and then save the format is this xlsm file.

Microsoft Office 2007 enables macros by Microsoft Excel spreadsheet programs, as well as embedded macro scheduling tables programmed in Visual Basic in the application program (VBA) language, saved in Open XML format introduced in Microsoft Office 2007.

XLSM files XLSX files are all excel2007 files, but the former is enabled with macros, and macros are not automatically enabled in Excel by default.

Excel does not execute macro XLSX files, even if they contain macro code, so files that contain macros can be saved as xlsm files.

In short, * .xlsm file: a XML-based Excel 2007 workbook with macros enabled.

. The default icon for the xlsm file with an exclamation point, as shown in the following figure: xlsm file

After saving the workbook containing the macro file, if the xlsm file icon does not have an exclamation point, it can only be opened normally and the macros in it can be run normally, then there will be no problem. Because the file icon (ICO) assigned by the system varies from system to system.

Extension: file icon modification method: my computer-tools-folder options-file types, in the "registered file types" to find "XLSM Microsoft Excel enabled macro worksheet", click "Advanced" below, open the "Edit File Type" dialog box, select "change Icon". This allows you to change the icon for the xlsm file.

Opening of xlsm

Since it is a file above the excel2007 version, you can open the xlsm file with the EXCEL2007 or excel2010 version.

Thank you for reading this article carefully. I hope the article "what xlsm refers to" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.