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

ExcelDataReader.AsDataSet() converts single fraction double value into multiple fractions

I'm facing a problem when reading the excel-sheet data using ExcelDataReader in c#. I am reading data from excel-sheet(.xlsm) One of the cell has a list of values to choose. Eg. 5.1 5.2 5.1a When I choose the value either 5.2 or 5.1a and…
Karthik Appavu
  • 1
  • 2
0
votes
1 answer

Way to convert from .xlsx to .xlsm?

So I found code on here to convert from .xls to .xlsm, but I would like to convert from .xlsx to .xlsm. Sub TrandformAllXLSFilesToXLSM() Dim myPath As String myPath = "C:\Excel\" WorkFile = Dir(myPath & "*.xls") Do While WorkFile <> "" If…
HopDevvil814
  • 55
  • 9
0
votes
1 answer

Unable to load xlsm and xlsx file using Infragistics.Web.Documents.Excel in dot net core 3.1 app

I am trying to load a file stream into the Infragistics workbook via the Workbook.Load(Filestream stream) function. And i am doing this in a dot net core 3.1 application using the latest package version 20.1.123 of the…
Sahil Chawla
  • 25
  • 4
0
votes
1 answer

Google Apps Script error 'Bad Request' when transferring a .xlsm-file to a GSheet

I have an Excel-File (.xlsm) as a Gmail-attachment in my inbox and want to transmit it to GDrive. There it should be saved as a GSheet. I am trying to automatize this process using Apps Script. Unfortunately, I get an error starting the Script.…
Lukas127127
  • 3
  • 1
0
votes
1 answer

How to add data into an existing xlsm file using editpyxl?

I am trying to add data to one cell in an existing xlsm file and then save it as a new xlsm file using editpyxl, but get an error stating the cell does not exist (IndexError: Cell A1 on TestSheet1 does not exist). There isn't much documentation on…
jamsup
  • 21
  • 4
0
votes
1 answer

How to temporarily block all macros from running and edit xlsm file with VBScript?

I have xlsm file which I need to edit. However, macros there block my script from editing. My code is following: xlsm_file_name = "webADI_template_Bankbuchungen_GL.xlsm" 'opening xlsm file and setting readonly to false set xlobj =…
Nikolay Oleynikov
  • 43
  • 1
  • 9
0
votes
1 answer

Why my XLSM, XLSX have to be repaired after saving with EPPLUS?

After saving a file with EPPLUS that is an XLSM, or XLSX, when opening it, I received this message: We found a problem with some content in 'YourExcelFile.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this…
flashsplat
  • 433
  • 3
  • 13
0
votes
1 answer

Workbook level events not firing in my .xlam

I have a simple .xlsm as follows: Private Sub Workbook_Open() Application.EnableEvents = True MsgBox "Workbook open" End Sub Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) MsgBox "Sheet Change" End Sub This works…
Crew Reynolds
  • 27
  • 6
0
votes
0 answers

Save errors - runtime '1004'

I have an issue runtime error 1004 with the below code, could anyone clarify for me what could be driving this? Sub Excel1() Dim rngLoopRange As Range Dim wsSummary As Worksheet Dim rngDealers As Worksheet Set wsSummary =…
Jack Staniforth
  • 13
  • 3
0
votes
0 answers

Converting PDF export into xlsm within looprange

I have an interesting issue where I am trying to have a looprange in effect and before looping to the next data point it will save a copy of the worksheet. Does anyone have any experience, when I try to make the changes it causes issues with my Next…
Jack Staniforth
  • 13
  • 3
0
votes
3 answers

How to create a XLSM file in Python

is there a way to create a new .XLSM file in python? (alternatively) Is there a way to create .XLSM file from a .XLS or .XLSX file within python? from openpyxl import Workbook wb = Workbook() wb.save('myExcelFile.xlsm') I tried the above but it…
ZAD
  • 51
  • 6
0
votes
0 answers

Excel doesn't recognize formulas when excel is exported and created from c#

I'm downloading an excel .xlsm from my application web, the problem is that when I opened there is a formula "=MyFunction(E16)" that appears as "#NAME?" so I think the formula isn't recognized. My file is protected so it can't be edited (only the…
MattDmc
  • 27
  • 6
0
votes
1 answer

Errno 13 permission denied when writing array on excel xlsm with python

I am trying to paste a covariance matrix on an existing xlsm file through the below formula, but it is not working. The Cov Matrix is an array. Could you please help me with it? Error I get is: [Errno 13] Permission denied:…
GM13
  • 19
  • 3
0
votes
1 answer

launch4j: java.lang.OutOfMemoryError: GC overhead limit exceeded

I added the poi-4.1.1.jar and all the libraries coming with to my java project for reading .xlsm files. After adapting the code, I could compile and run it in Eclipse without any problems. I export > Runnable JAR file > Extract required libraries…
alpefredi
  • 1
  • 2
0
votes
1 answer

Why do I get Workbook Close Runtime error 91?

I want to close the other open workbook via a macro below. It gives this error: Run-Time Error '91': Object Variable or With Block Variable Not Set Sub Macro1() Dim wb As Workbook Set wb =…
rnyc
  • 1
1 2 3
…
17 18