What file is xlsm?

xlsm is the format file of OFFICE2007, and XLSX files are also excel2007 files, but xlsm files contain macros enabled; Excel will not execute macros on XLSX files, even if they contain macro codes, so files containing macros can be saved as xlsm file.

The operating environment of this tutorial: windows7 system, OFFICE2007, Dell G3 computer.

What is xlsm file?

.xlsm file is the format file of OFFICE2007. The macro code is added to the EXCEL2007 file, and the format saved is this xlsm file.

Microsoft Office 2007 enables macros to be saved by the Microsoft Excel spreadsheet program, as well as embedded macro schedulers programmed in the Visual Basic for Applications (VBA) language, in the Open XML format introduced in Microsoft Office 2007.

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

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

In short, *.xlsm files: XML-based, macro-enabled Excel 2007 workbooks.

The default icon of an xlsm file has an exclamation mark, as shown in the figure below: xlsm file

After saving a workbook containing macro files, if the icon of such an If you open it normally and run the macros in it normally, there will be no problem. Because under different systems, the file icons (ICO) assigned by the system are different.

Extension: How to modify the file icon: My Computer - Tools - Folder Options - File Types, find "XLSM Microsoft Excel Macro-Enabled Worksheet" in "Registered File Types", click Click "Advanced" below to open the "Edit File Type" dialog box and select "Change Icon". This way you can change the icon for the xlsm file.

Opening xlsm

Since it is an excel2007 or above file, you can use EXCEL2007 or excel2010 version to open the xlsm file.

Recommended: "Programming Video"

The above is the detailed content of What file is xlsm?. For more information, please follow other related articles on the PHP Chinese website!