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
0
votes
1 answer

Excel macro help to add timestamp and username

I have been playing with the following code. It works the first time, but then it appends another timestamp on the filename that already was timestamped before. I would like this to create a new filename in the same directory with format 2018…
JR2018
  • 1
  • 1
0
votes
0 answers

Error in reading xlsm file with R

I have a xlsm file (please look at the photo below) and I want to: Skip the first 4 rows Use the 5th row as variables names I tried with read_csv("Sujet8.xlsm", skip = 4) but it returned me this error: Error in read.table(file = file, header =…
SiXUlm
  • 159
  • 3
  • 12
0
votes
1 answer

Evaluate cell which uses named field in its formula - Apache POI

I'm having a problem evaluating excel sheet cell which uses named cell in its formula. I'm using apache-poi version 3.17, java 1.8 and the file I'm working with is .xlsm. Here is an example code: //Getting the excel file from the database Document…
antonionikolov
  • 97
  • 1
  • 1
  • 8
0
votes
1 answer

How to read large xlsm files using apache POI

I am trying to read a large xlsm file for which i am getting heap space error,i am using XSSFWorkbook for the large file but still i am getting this .And also i have set the VM argumets -Xmx1024m to eclipse.Here is my code public class TestSJXLSX…
Mandrek
  • 1,159
  • 6
  • 25
  • 55
0
votes
1 answer

EPPlus Adding VBA Code Corrupts resulting xlsx file

I'm creating an excel file using EPPlus from a datatable and saving it to a file, all fairly standard. This works without any hassles. However, if I create a vba project, and add any vba code, the resulting .xlsx file is suddenly corrupted. When try…
J. Minjire
  • 1,003
  • 11
  • 22
0
votes
1 answer

Is there any npm package to read Excel file which is in .xlsm format?

I am having a base template which is in the .xslm format and I want to read this file and preserve all those VBA and macros in it I tried using npm's xslx package it preserves the VBA and macros but I am loosing all data validations and styles.I…
Jaspher J
  • 29
  • 9
0
votes
2 answers

after run macro to save as xlsx file, the macro file convert to xlsx file

I want the macro to backup my xlsm file as xlsx format, still remain there after save as xlsx type. However, below coding will convert the existing xlsm file to xlsx file, causing my macro file dissapear. Any suggestion to avoid this, I want xlsx…
Amos
  • 15
  • 1
  • 7
0
votes
1 answer

How to read values from macro cells in excel using python 3

I am trying read the content from macro based xls file(.xlsm) in python by using openpyxl library. I want to read the value from the cell, but i am getting the macro formulas instead of populated values from macro in cell. Is there any way to get…
Nitesh Palankar
  • 11
  • 1
  • 3
0
votes
0 answers

XLSM files parsing with Laravel

I am developing an application where the user can upload data from an Excel file. So I'm trying to parse a xlsm file (Excel file with macros), I've been looking for solutions. I've found Maatwebsite, that looked good but the problem is in the file…
Alexandre Thyvador
  • 364
  • 1
  • 10
0
votes
0 answers

PHPexcel can not write column

I am editing .xlsm file. Which has macro and multiple tabs. EDIT I tried with macro enable .xlsx file but same issues. I always get below error when save file after editing. Fatal error: Uncaught exception 'PHPExcel_Exception' with message …
silentcoder
  • 992
  • 3
  • 9
  • 21
0
votes
0 answers

Write data in xlsm using OpenTBS

I'm trying fill data in .xlsm template, which contain lot of VBA calculations. When I open merged file in MS Excel, file is corrupted and Application propose repair it. After repairing, I see new blank sheet, and lost formatting in old sheet which…
Alexey Sharavara
  • 23
  • 3
0
votes
2 answers

Add only xlsm files to combobox VBA

It's my first time asking something in this forum, i have this code that adds some files to a combobox in a User Form, but the thing is i only need to add the .xlsm files, but the code i came up with adds me every file, how can I do something like…
Jake.Casillas
  • 23
  • 5
0
votes
0 answers

Epplus:- Referencing a cell from another worksheet, then how to get calculated values from .xlsm file

I am using EPPlus library to get all requirement as per our need. I am not getting how to get calculated value of the cell which has reference of another worksheet in the same .xlsm file (macro enabled).Can any one help?? After hitting…
Vineet Kumar Rai
  • 31
  • 1
  • 9
0
votes
0 answers

How to take screenshot of a particular file using pyscreenshot

I want to write a python script that can take a screenshot of an excel file located at: /Users/Desktop/Automation/file.xlsm Right now I'm using pyscreenshot and doing it in the following way: import pyscreenshot as ImageGrab import…
Reshma
  • 21
  • 1
  • 4
0
votes
0 answers

How to manipulate excel files xlsm using python 3

good afternoon. I have a problem with my work and I can not solve it. First problem: I need to read some values ​​in an xls file and place them in specific locations in an xlsm file daily. I can read the values, however I can not write to the xlsm…
Hugo Baurq
  • 11
  • 1
1 2 3
…
17 18