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
2 answers

VBA to paste only values instead of paste every thing

I am working on a small project which requires me to search for a word through one column then copy the entire row that contains my word into another sheet. This is my code and what I have so far: Sub SearchForString2() Dim LSearchRow As…
Mouneer
  • 12,827
  • 2
  • 35
  • 45
0
votes
3 answers

How to import xlsm file into Access

How does one import a xlsm file into Access? Naturally, Access gives me the "Please check that the file exists and is in the correct format" error. How ought I to progress? Working in 2010 for both Excel and Access.
jph
  • 13
  • 1
  • 3
0
votes
1 answer

NPOI: Convert Xlsm to Xlsx

I'm writing a program to process some excel documents, the program is written in C# in Visual Studio 2010, and I'm using the NPOI library. I notice the I was not able to use CloneSheet() for the xlsm file, but I was able to do so with…
sora0419
  • 2,308
  • 9
  • 39
  • 58
0
votes
1 answer

Softartisan Officewriter does not create excel format with .xlsm extension

I want to create new excel sheet with .xlsm extension by using softartisan dll, however in create method of softartisan does not have xlsm format. It has only .xls and .xlsx formats. My new excel contains macros hence I need .xlsm format. Code is as…
user3304711
  • 3
  • 1
0
votes
1 answer

How to open and edit an XLSM file online

friends, I have a Macro enabled excel file. How and where I can upload my Xlsm file and do the updation. I mean, I want my HR people to do the updation on regular basis on this XlSM file from the branch office and myself want to see the updated XLSM…
Anesh
  • 33
  • 1
  • 7
0
votes
1 answer

Read using XSSF SAX and stream out data with SXSSF - POI

I have to read large sized xlsm with low memory footprint and since apache POI provides XSSF SAX, I should prefer using it. In the first sheet from existing xlsm parsed with SAX, i need to append some data from db and write it out as another xlsm.…
Sva
  • 115
  • 1
  • 12
0
votes
1 answer

worksheet_change save in xlsx

Does the excel file have to be xlsm for the worksheet_change event to work, or can this be done in xlsx. I fear it's only xlsm. Although it seems like a small thing, asking some co-workers to select 'enable macros' seems to be too much to ask
John Henry
  • 165
  • 1
  • 4
  • 14
0
votes
2 answers

Perform excel macro on a csv file from C#

I need to perform an existing Excel Macro (written in VB, can be copied from Excel using the Macro editor) on an existing csv file using C#. I already have working code that I can use to perform the Macro on an xlsm file, which looks like this:…
dereknord
  • 1
  • 4
0
votes
1 answer

How to call jar file using VB SCRIPT in excel and hold screen

I want to call a java jar file using vb script in excel. My file format is "xlsm" where is my vb script code. When i execute my code, then console comes and go, I do not what is written on console. please have a look at code Public Function…
learning_programming
  • 35
  • 2
  • 6
0
votes
1 answer

Excel Cut And Paste Specific Characters

I wish to create a macro that will cut characters 49 thru 56 from each cell in a column and paste those characters in the column directly to the right. There are 4000 rows of data that need to be manipulated. Examples of data: Stop: Coggins Drive…
Phil Garth
  • 1
0
votes
0 answers

error while reading .xlsm file

I am trying to read a .xlsm file using POI. My code is: import java.io.*; import java.util.List; import jxl.*; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import jxl.read.biff.BiffException; import…
ramansingh
  • 45
  • 8
0
votes
1 answer

Creating an xml container using xmlst

I am trying to normalise a piece of xml. I am having trouble with the section relating to ProductID. I am trying to creatre a container for it xyz by my does not seem to…
Paul Ellaway
  • 101
  • 1
  • 3
  • 8
0
votes
2 answers

Excel 2010 - Conditional Formatting

I have a spreadsheet that I would like columns that relate to Saturday and Sunday to automatically colour fill. As the months and years change I would like for the formatting to recognise the weekends and fill the columns accordingly.
user1407241
  • 1
-1
votes
1 answer

Copy the fifth value from a specific cell in an Excel spreadsheet using Python

I would like to use the df.iloc command to extract the 5th value from the cell. The cell contains the following value: UTM ETRS 89 zone 32N I just want the value "32N" from the cell. What would I need to add to the command to just output…
Mohammad Parwiz Walizadah
  • 11
-1
votes
1 answer

Excel Dependent User Form Dropdown List Won't Update

I want to create 2 dependent dropdown lists (form contorl) with VBA: Listadesplegable1: The first dropdown list selects between 4 different cases. Listadesplegable5: The second dropdown list selects the different options of each case. Here's the…
maxipoblete
  • 57
  • 4
1 2 3
…
17
18