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.

270 questions
5
votes
1 answer

How to convert .xlsm (macro enabled excel file) to .xlsx using Python?

I am trying to import data in an .xlsm file as a data frame. When I import the .xlsm file using the command below, it gives me an empty data frames as the result: exp = pd.read_excel(File_Path+'file_name'.xlsx',sheetname='Data',header=None) I have…
Mahita
  • 61
  • 1
  • 1
  • 4
5
votes
1 answer

How to work with .xlsm via C# .NET?

I have C# app for deleting first few rows from excel and then format file to .csv, but now i got not .xlsx but .xlsm and i cant find how to work with, i cant even load data from columns. Its some report file from SAP and i dont find any macro…
Muflix
  • 6,192
  • 17
  • 77
  • 153
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
  • 3,004
  • 3
  • 29
  • 37
5
votes
3 answers

Convert XLSM to XLSX

I'm using the EPPLUS library to read data from Excel to create another file. Unfortunately it does not support the .XLSM extension file. Is there a nice way to convert .XLSM files to .XLSX file for the purpose of reading the file with EPPLUS? …
user1167650
  • 3,177
  • 11
  • 34
  • 46
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
  • 3,115
  • 7
  • 31
  • 44
4
votes
1 answer

Closing a "At statup, open all files in:" file

I currently have a folder set up on my C drive called "XL Startup". This is referenced to open all files in this folder when Excel is started. The files that exist within this folder is called "mymacros.xlsm" & "CopyMacro.xlsm". These are files…
Brad
  • 1,450
  • 2
  • 16
  • 37
4
votes
1 answer

Workbook.save - "the following features cannot be saved in macro-free workbooks..."

My sub opens up a .xlsm file in a new Excel instance, makes changes to the file, and saves the changes. However, despite the fact that the file being opened is .xlsm, upon workbook.save I get the alert message "the following features cannot be saved…
Sayjota
  • 128
  • 1
  • 1
  • 8
4
votes
1 answer

PHPExcel XLSM file with macros

Is it possible to read and write xlsm with macros file with phpexcel? I tested this code just to replicate the original file: $objReader = PHPExcel_IOFactory::createReader('Excel2007'); $objPHPExcel = $objReader->load("file1.xlsm"); echo…
user3770270
  • 51
  • 1
  • 6
4
votes
2 answers

java.lang.NoSuchMethodError when trying to read .xlsm file

Exception in thread "main" java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlOptions.setSaveAggressiveNamespaces()Lorg/apache/xmlbeans/XmlOptions; at org.apache.poi.POIXMLDocumentPart.(POIXMLDocumentPart.java:56) at…
DT7
  • 1,615
  • 14
  • 26
4
votes
3 answers

How to write an ampersand to an XML file from an Excel file using VBA?

First of all, I'm a complete newbie when it comes to VBA, but unfortunately I was dumped this code and I have to deal with it... What the application does is copy the information inside an Excel xlsm file and paste it in an XML file for further…
pteixeira
  • 1,617
  • 3
  • 24
  • 40
3
votes
1 answer

Powershell import of a CSV file with line break in the header

For a project i would need to export data from an .xlsm file data to a CSV file and then process it with powershell. I do the export manually. In the original file, there are line breaks in the headers, which are also transferred to the CSV file. My…
Eduard M.
  • 57
  • 1
  • 4
3
votes
3 answers

SignTool: can't sign XLSM (DOCM)

I have a litte problem with Microsoft SignTool.exe. I have installed Windows 10 SDKs and Office SIPs to support macro enabled documents. Then I followed readme to activate dlls and made all the changes, including: Installed - Microsoft Visual C++…
Dmytro
  • 372
  • 2
  • 12
3
votes
5 answers

openpyxl error raise ValueError('Min value is {0}'.format(self.min)) in opening heavy file with formatting

I'm trying to use openpyxl for the first time on a very heavy file, that happens to be over 20 500 Ko, has a lot of formatting and a VBA macro. My code keeps returning the following error: File "…
Clara Loizeau
  • 77
  • 5
3
votes
2 answers

react-data-table-component with nested tables

I am using react-data-table-component in a node/react page. I have 2 data sets, List and ListNested. list is a collections of document data (xlsm to be specific) that has the most recent version of the document on each row. listNested is a similar…
cHam
  • 2,624
  • 7
  • 26
  • 28
3
votes
1 answer

how to update existing xlsm sheet with macros using pandas, openpyxl, xlwings without losing macros

First of all, I'll discuss my need from this post..... Now I need to update existing excel xlsm file from another excel csv file, as this csv file is an exported csv from outlook mail inbox and this is the template of my outlook mail…
user11630968
1
2
3
…
17 18