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
3
votes
0 answers

phpspreadsheet - PHP - How to add new data into an existing .xlsm file

I am trying to take data from '.csv' files and put it into specific cells inside a '.xlsm' file. I'm doing this with PHP and the PHPSPREADSHEETS library. So far I've gotten to a part where I can add data to an '.xlsx' file, but as soon as I try to…
Carlove
  • 429
  • 1
  • 4
  • 15
3
votes
0 answers

Updating Excel document with macros

Using the Microsoft Graph API with Office 365, I've not been able to update a .xlsm file with macros, even if all I'm changing is a row of data. If I open the file in the web version of Excel (Office 365) and make an editable copy and re-save The…
barnabus
  • 862
  • 7
  • 26
3
votes
1 answer

How to read and append a .xlsm file in java

I want to read and append a .xlsm file in java. I dont have any idea on how to do it. Do i need to download any jar file to work with it? All the search result provides a solution which uses apache poi(I did not get what it is). I dont use any…
Vandhana
  • 501
  • 2
  • 7
  • 14
3
votes
2 answers

Convert .xlsm to .xlsx in R

I would like to convert an Excel file (say it's name is "Jimmy") that is saved as a macro enabled workbook (Jimmy.xlsm) to Jimmy.xlsx. I need this to be done in a coding environment. I cannot simply change this by opening the file in Excel and…
user3580643
  • 111
  • 3
  • 11
3
votes
4 answers

paste special values in vba

I am working on a small project which requires me to copy and paste certain columns if I detect "true" in the row. I am trying to paste these selected columns onto a different sheet and I want to paste only their values not the formulas. This is…
user1452091
  • 123
  • 3
  • 4
  • 10
2
votes
2 answers

Excel 2016 able to save workbook with macros as .xls but detects errors upon save as .xlsm and .xlsb

I have an issue where certain workbooks (.XLSM) with included macros and conditional formatting are not saving properly on my Windows 10 machine. I have not been able to determine what is triggering the issue... Upon trying to save even just a minor…
Martin
  • 401
  • 6
  • 15
2
votes
1 answer

Temporarily set default file type in Save As dialogue Excel

I'm making a template for macro addins in Excel. Addins have this weird thing that when you close them Excel won't prompt you to save. So I want all my addins to inherit from a template with this code: Private Sub Workbook_BeforeClose(ByRef Cancel…
Greedo
  • 4,967
  • 2
  • 30
  • 78
2
votes
2 answers

Importing data from multiple closed workbooks based on variable defined path

I have hit a wall in trying to find a solution to my problem. Here is a summary of what I am trying to do: Situation: I receive 4 identical worksheets weekly and I need to combine data on my summary worksheet: Year Week Town 1 Town 2 Town 3 Town…
bulldogdad_nyc
  • 21
  • 2
2
votes
0 answers

ActiveX button not working when saving .xlsm file with openpyxl

I have a .xlsm file containing a macro which is activated with an ActiveX button. When I save the file with openpyxl, and open it again, the ActiveX button has been converted to a picture. The macro is still there, but the button cannot activate the…
Neil
  • 49
  • 5
2
votes
1 answer

Library for C# to read Excel 2007 xlsm file?

Does someone know library for C# to read xlsm file (Excel 2007 with macro) ? I've downloaded EPPlus, it read xlsx files but it has an error New line format. Thanks
Robert
  • 2,571
  • 10
  • 63
  • 95
2
votes
1 answer

Is my vba code lost when saving to google drive?

I have uploaded an xlsm file to google drive. When opening it uses google sheets, and when downloading it converts it to xlsx (no vba modules). Is there another way to get my code back? (The original file on my computer is gone).
JackTeacher
  • 51
  • 4
2
votes
1 answer

Edit Excel XML Worksheet File from XLSM in PHP

I have an XLSM File, where I need to edit some Cell Values with PHP. As I couldn't find a proper library, which can actually edit an xlsm file (most read excel and create a whole new excel file, which in this case would delete the macros inside the…
Niklas Riecken
  • 303
  • 1
  • 6
  • 20
2
votes
0 answers

How to convert VBA file in PERL to vbaProject.bin directly without using the excel file?

Or compile VB file to .exe in Perl? I am using the unzip command to extract the VBA-bin from the sample XLSM excel file. unzip -j xl/sample.xlsm xl/vbaProject.bin I have the same macro code in the sample.vb file in a git directory. I am generating…
himmat
  • 159
  • 5
2
votes
0 answers

How can I extract the name of the MACRO present in .xlsm files using python

I have got a large amount of file of .xlsm format in a folder and each file contains MACRO and I want to extract the name of each MACRO present in those files. How can I do it? Apology If I've done any mistake in asking the question. i.e This is my…
Mayank
  • 41
  • 4
2
votes
3 answers

is there any way to create a .xlsm file from scratch in python?

I am using python 3.8.1 on a mac and am trying to create a .xlsm file from scratch. I have looked at openpyxl and xlsxwriter, both of them are able to create .xlsx files from scratch and both can edit existing .xlsm files but I can't find any thing…
Gharbad The Weak
  • 1,541
  • 1
  • 17
  • 39
1 2
3
…
17 18