Stack Overflow
Stack Overflow

Questions tagged [xlsm]

.xlsm is one of the file extensions for files created by Microsoft Excel (Excel 2007 or later). This format can store macros written in VBA.

Starting from Excel version 2007, Microsoft changed the format of the Microsoft Office files.

Formerly, Microsoft used the BIFF (Binary Interchange File Format) binary format (.xls, .doc, .ppt). It now uses the OOXML (Office Open XML) format. These files (.xlsx, .xlsm, .docx, .docm, .pptx, .pptm) are zipped-XML.

.xlsx is the new default Excel format, it cannot contain any VBA (for security reasons as stated by Microsoft).
.xlsm is the new Excel format that can store VBA and execute macros.

225 questions
109
votes
5 answers

When should the xlsm or xlsb formats be used?

Since Excel 2007, Microsoft has split the classical .xls format to several formats (in particular, .xlsx, .xlsm, .xlsb). I've got no problem to understand the use and purpose of .xlsx format but I am still wondering whether we should use a .xlsm or…
JMax
  • 24,408
  • 12
  • 63
  • 87
20
votes
6 answers

How to save XLSM file with Macro, using openpyxl

I have .xlsm file with a Macro function. I'm loading it using openpyxl and write some data to the file and finally want to save as a different .xlsm file. To save the file as XLSM file I have used below code in my Python…
AnujAroshA
  • 4,275
  • 6
  • 46
  • 90
18
votes
11 answers

User Defined Functions NOT recalculating

I recently took a large, stable XLSM file, and split it apart into an XLAM and XLSX. Thousands of cells in the XLSX call (udfs) functions in the XLAM, and each such udf begins with the statement "Application.Volatile" (overkill, to force…
tpascale
  • 2,436
  • 5
  • 22
  • 37
8
votes
3 answers

How to extract sheet from *.xlsm and save it as *.csv in Python?

I have a *.xlsm file which has 20 sheets in it. I want to save few sheets as *.csv (formatting loss is fine) individually. Already tried xlrd-xlwt and win32com libraries but could not get through. Can anybody please provide a code snippet which…
iPirate
  • 93
  • 1
  • 1
  • 5
8
votes
2 answers

write to xlsm (Excel 2007) using apache poi

I have written java file for writing xlsm(Excel 2007). Using Apache POI Library, Writing xlsx file is success. And Writing xlsm file is success. But I can't open the xlsm file because of error when open xlsm file. Would it feasible to write xlsm…
user2636961
  • 215
  • 1
  • 2
  • 6
8
votes
3 answers

Does the xlsx package work for xlsm files in R?

I am trying to read a range into a data.frame from a xlsm workbook. Can I do this with the xlsx package in R? If not, does anyone know of a way to do it? Thank you!
overflowname
  • 1,631
  • 3
  • 12
  • 10
7
votes
4 answers

Parse xls/xlsx/xlsm in Node.js

Running in Node.js, I need to be able to parse cell value's from Excel .xls,.xlsx, and .xlsm. Are there solutions available? I doubt there's a single module out there that will do the trick, so perhaps there is a way to internally convert two of the…
gone
  • 2,397
  • 6
  • 22
  • 31
7
votes
2 answers

How to get the value of a cell at a specified position in an excel sheet using JAVA

How to get the value of a specific cell from a .xlsm file using java ..?? I want to fetch the cell value by specifying the particular row and column for example i need the cell value at row 1 and column C1 or row5 and column C6 ... I am getting the…
Kartik P
  • 71
  • 1
  • 1
  • 4
6
votes
3 answers

Pandas open_excel() fails with xlrd.biffh.XLRDError: Can't find workbook in OLE2 compound document

I'm trying to use pandas to parse an .xlsm document. My code worked perfectly with the example file I was given, but once I got the rest of the documents, it failed with the above error. Here's the offending stack trace: Traceback (most recent call…
bendl
  • 1,467
  • 18
  • 35
6
votes
1 answer

Exclamation mark on .xlsm file

i've prepared one excel file with Visual Basic code. It was saved with .xlsm extension. And now the excel icon is appeared with exclamation mark that is irritative. Can I remove that exclamation mark from the icon?
Pina Parmar
  • 61
  • 1
  • 1
  • 4
5
votes
2 answers

TypeError: This COM object can not automate the makepy process - please run makepy manually for this object

What this kind of error? Traceback error C:\Users\DELL\PycharmProjects\MyNew\venv\Scripts\python.exe C:/Users/DELL/PycharmProjects/MyNew/agaaaaain.py Traceback (most recent call last): File "C:\Users\DELL\PycharmProjects\MyNew\venv\lib\site-…
user11630968
5
votes
2 answers

"ThisWorkbook.Close" Causes excel to crash

I have a large collection of excel files that work almost like a program, and they run on multiple computers (with different versions of windows), and as of latelly I have this bad problem, when the user presses my close button(actually a picture I…
Diego Castro
  • 3,260
  • 4
  • 32
  • 42
5
votes
2 answers

Suppress dialog when using VBA to save a macro containing Excel file (.xlsm) as a non macro containing file (.xlsx)

How do I suppress the dialog that says "Visual Basic macros will be removed if you save the file in this format. Are you sure you want to use this format?" (see picture below). Essentially, I'm trying to use a macro to save a .xlsm file as an .xslx…
D. Woods
  • 2,604
  • 3
  • 23
  • 36
5
votes
0 answers

Edit Excel 2007 (.xlsm) file in PHP

I'm developing a webapp using PHP (Zend Framework) & JS (extJS 4) that reads Excel files sent by our customer. The problem is they use macro a lot, meaning all the files sent are in xlsm format. We read the files and update our database with the…
3rgo
  • 2,863
  • 6
  • 28
  • 44
4
votes
1 answer

Read and write a xlsm file using exceljs package npm

I have a xlsm file with few data already in it and need to write some data and create a new xlsm file during automation. With below code the file gets created , but it becomes corrupt and unable to open. File size reduces, for ex from 8kb to 7kb.…
Nalu
  • 145
  • 10
1
2 3
…
14 15