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

Copy .xls sheet into .xlsm sheet

I have .xls file with several sheets. I have .xlsm file with several sheets. I want to copy xls.sheet(x) into xlsm.sheet(y). I tried the following code: try XLTo := CreateOleObject('Excel.Application'); XLFrom :=…
Amos
  • 1,321
  • 2
  • 23
  • 44
0
votes
1 answer

Automatically Replacing Text to Clean Data

I would like a way to replace all different names for a country and replace them with one name to make future pivot tables more effective. For example: If the country column has a bunch of different rows containing GBR, GB, UK, United Kingdom,…
jf12345
  • 25
  • 1
  • 6
0
votes
1 answer

Best way to generate a .xlsm file from Oracle?

I have a requirement to generate a macro enabled .xlsm file from Oracle and was wondering the best way to achieve this. The file is multi tabbed and includes various buttons and macros however all that I need to generate is the table data from the…
ls_dev
  • 201
  • 4
  • 15
0
votes
0 answers

Getting org/apache/poi/UnsupportedFileFormatException

I tried the following code to read the contents of .xlsm file import java.io.FileInputStream; import org.apache.poi.ss.usermodel.WorkbookFactory; public class ReadMacroExcel { public static void main(String[] args) { try { …
Vandhana
  • 501
  • 2
  • 7
  • 14
0
votes
0 answers

Uploading a lot of files from Excel to MySQL

I have a problem, I must upload every week to a MySQL database hundreds of excel files .xlsx and .xlsm. I started whit the "LOAD DATA LOCAL INFILE" and converting all the files to CSV. The problem is when I convert hundreds of files to CSV I use a…
Daniel Palomino
  • 19
  • 1
  • 5
0
votes
1 answer

"xlwings" : does not support writing of .xlsm files?

I've tried a simple test using "xlwings_0.3.4" to open an excel .xltm file and save it again, to make sure that the VBA modules are kept. I couldn't get it to work. If I give a file extension in the save step, the file is saved as an .xlsx file. The…
BPT
  • 1
  • 1
  • 1
0
votes
0 answers

Determine the number of days a bill range falls into two different date ranges

I am trying to calculate how many days a utility bill falls within two categories (date ranges).i.e. a bill range may be between 16/8/14 - 14/10/14 (total of 60 days incl) and I want to work out how many days fall in the 1/10/2014-31/3/15 season…
Ingrid
  • 1
0
votes
1 answer

Issue with Microsoft excel XLSM

I have created an XLSM file which captures data from another Excel file and does some calculation. It works on my machine but if I send the XLSM to other's it doesn't work. Also recently I had to re-install OS and Office (same version as earlier),…
Sambhav Jain
  • 1
0
votes
2 answers

"Compile error: Method or data member not found" with previously working code

As the title suggests, I'm getting the above error with code that was working 6 days ago. Code since omitted - apologies DurationCombo is an ActiveX ComboBox which resides on Sheet1. I can provide an image of the ComboBox:…
Scott Parker
  • 1
  • 1
  • 4
0
votes
2 answers

Can we convert xlsm to xlsx using POI apache

It is possible to convert xlsm file to xlsx file using Apache poi. I am trying to writing a xlsm file but after writing i want it to be converted into xlsx file. can you give me any solution.
Anamika Jain
  • 1
  • 1
0
votes
0 answers

creating .xlsm file from a string data

I need some help with creating .xlsm file from a string data in java. I have a .xlsm file with multiple sheets, stored as text in sybase database. I read this file content from the database in a java string and now I want to create .xlsm file from…
Kabeer
  • 69
  • 1
  • 5
0
votes
2 answers

xlsm into sql server

I have an xlsm file with macros that enable data collection from OLE DB source. I just need to make an import package with it in sql server. But when I'm trying to use import/export wizard or ssis-it shows that it can not deal with .xlsm…
Keithx
  • 2,994
  • 15
  • 42
  • 71
0
votes
1 answer

Need batch file to open all .XLSM files in a folder one at a time (open next after previous closes)

I have a folder with 100+ .XLSM files. They are each set to auto-run a sequence, save and close when opened. I currently have a batch file set to open each file in the folder. However, I've only been able to set a "delay" before opening the next…
Bret
  • 1
  • 1
  • 2
0
votes
1 answer

Excel 2003 - 2007 File Converter breaks workbook-relative file paths to other workbooks

We have a product based on a set of Excel workbooks which runs on Excel 2003 onwards. Some of the workbooks open other workbooks in the same directory to use as data stores. Recently, in trying to port this to the Mac Excel 2011 platform, we…
Arkitec
  • 333
  • 3
  • 17
0
votes
0 answers

How to convert xls file to xlsm in c#

I am working with ClosedXML utility for excel operations. It only supports files created on office versions 2007 on-words. I have an xls file and required to convert to xlms(macro enabled). Simple copy as shown below is not working. string oldFile =…
Razack
  • 950
  • 3
  • 13
  • 26
1 2 3
…
17 18