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

Consolidating Excel worksheet rows into one worksheet in the same workbook

I have an Excel workbook that has several worksheet (by team member name). Each team member maintains a list of projects/tasks. All column titles in each worksheet are identical. I need a worksheet within the same workbook that consolidates all…
EDC
  • 21
  • 1
2
votes
0 answers

Error while downloading .xlsm excel sheet through a popup window

We have to provide a download option to an .xlsm (macros enabled) excel sheet by creating the popup window. While downloading the excel sheet, it is throwing the below error. Excel cannot open the file "null.xlsm" because the file format or file…
Sanjeev
  • 21
  • 1
2
votes
2 answers

Error while reading an xlsm file using POI Framework in Java

I am not able to read an xlsm file using the POI Framework (HSSF). I am getting the following error while reading an xlsm file. The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office…
user1740278
  • 21
  • 1
  • 2
1
vote
1 answer

Way to convert from .xls to .xlsm via a batch file or vba?

How to I automate the conversion of .xls workbooks to .xlsm?
BING
  • 21
  • 1
  • 1
  • 2
1
vote
1 answer

Workaround for XLSM issues

My company receives a daily CDR report from Comcast and I'm trying to get this data into our database in an automated fashion. Unfortunately, Comcast has advised there is a 0% chance they send us a CSV or XLSX or anything that is NOT an XLSM. For…
Bruno
  • 21
  • 1
  • 6
1
vote
2 answers

Create copies of template XLSM file using NodeJS?

I have a node project where I need node to create a new XLSM file using an existing XLSM file as a template. The template contains a great deal of styling, images, and VBA. The application simply inserts values into a few cells and saves the new…
Erik Portillo
  • 11
  • 3
1
vote
2 answers

Excel file gets corrupted after bulking data with panda

Ok so apparently this is a very simple task, but for some reason it's giving me trouble. Here's the code: marcacoes = pd.read_excel(file_loc, sheet_name="MONITORAMENTO", index_col=None, na_values=['NA'], usecols ="AN") x=0 while x <…
Mulon
  • 61
  • 6
1
vote
0 answers

Xlsxwriter with xlsm file trouble

I was wondering if its possible to write text into a cell that lies in a xlsm file using xlsxwriter? I have tried to do it on my own but it corrupts my workbook. Any ideas? My code is import xlsxwriter text = 'hola amigos' book =…
ChickenPotPie11
  • 11
  • 2
1
vote
3 answers

copy and paste from xlsm to csv

I am trying to copy from a macro enabled workbook to a .csv file, but for some reason the paste part paste everything in Column A only. VBA coding is below. Please help me figure out why it will not paste into the same cells as it copies. When I run…
Omar
  • 53
  • 1
  • 6
1
vote
1 answer

read xlsm file in js

I'm reading xlsx file in javascript using following code: this.parseExcel = function (file, id) { var reader = new FileReader(); reader.onload = function (e) { var data = e.target.result; var workbook =…
Kamana Trivedi
  • 11
  • 2
1
vote
0 answers

Apache POI is using too much RAM in XLSM files

Recently I was working on a report using Java and Apache Poi which had macro in the xls file template, however the amount of data that was sometimes generated exceeded the capabilities of the xls format, in order for the macro to work I decided to…
Piotr Lepa
  • 21
  • 4
1
vote
1 answer

vba: locate reference for a type (e.g. "Dictionary") in an Excel xlsm file

in this line, 'Dictionary is included in the reference "Microsoft Scripting Runtime" in a working project that already has that reference: Dim myVar as Dictionary How can I locate which library it references to, without googling it ? In this case,…
Roger
  • 333
  • 2
  • 13
1
vote
2 answers

Error while copy pasting ranges across sheets xlwings

I want to copy paste ranges for sheets in my .xlsm workbook using xlwings.I want to maintain the source formatting and the leading single quote because of which I've used the .copy , .paste method. I'm getting this error while trying to run the…
Scope
  • 727
  • 4
  • 15
1
vote
0 answers

Why my batch file stops working on Windows 10?

I have a batch file which calls .xlsm, access and sqlcmd. I scheduled the batch file in task scheduler for every day. When we used Windows 7 on computer, it worked perfectly. After upgrading to Windows 10, most of the cases it stops running after…
Hajnalka
  • 11
  • 3
1
vote
1 answer

What is the Perl module to read XLSM file?

My code works great for the XLSX file but it breaks at the XLSM input file. Requirements Read Excel's whole row rather than cell value. I don't want to use my $parser = Spreadsheet::ParseXLSX->new(); my $workbook =…
himmat
  • 159
  • 5
1 2 3
…
17 18