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

How to open Excel macro files (xlsm) in separate instances of Excel 2016/win10

Does anyone know what registry keys need to be modified in order to open macro enabled excel files in a separate instance of Excel (ie: separate windows)? I followed the instructions on the following pages Microsoft How-To (if you want to open…
Fractal
  • 1,748
  • 5
  • 26
  • 46
0
votes
1 answer

Automatically run data connections in XLSM

I have an XLSM file which contains 2 Web Query connection. When I go to "Connections" in the "Data" tab I am presented with the two connections I have. For each of these I can edit some properties, one which says "Update every X minutes". I've set…
Linora
  • 10,418
  • 9
  • 38
  • 49
0
votes
0 answers

Can I navigate a WebBrowser control to embedded image inside Excel file?

I have an .xlsm file with an ActiveX Microsoft Web Browser control ("Shell.Explorer.2"). I use VBA to open an image inside of it: WebBrowser.Navigate Application.ActiveWorkbook.Path & "\image.gif" I know that if I put an image on the worksheet it…
hypers
  • 1,045
  • 1
  • 12
  • 30
0
votes
1 answer

Issue downloading .xlsm document with activex controls using NPOI

I am trying to implement an excel file download functionality in my asp.net MVC application and using NPOI. The file has three sheets and Sheet2 has two activex buttons. I am reading the source file, adding values to sheet2, save it in temporary…
RandomUser
  • 1,843
  • 8
  • 33
  • 65
0
votes
0 answers

Export xls file to xml with existing xml schema

I am having a xlsm file and I need to export one sheet from that file to an xml file. I am having a predefined xml schema and i have to do it from the command line. Can anyone help with this problem?
Luka Klarić
  • 323
  • 2
  • 16
0
votes
1 answer

Why would a macro from a different workbook be inaccesible after allowing macro's?

I have an .xlsb file, which I'm running on a different computer, after defining the paths variable and dependent on its current location. I added the VBA Project of a different xlsm file to the .xlsb. And I'm trying to run a macro from Module 2 of…
Maximilian brutus III
  • 643
  • 9
  • 21
0
votes
0 answers

Error in *.xlsm file when writing strings using xlsm

I am using openpyxl (2.3.2) to write out an xlsm file. I can write the numeric values correctly but the string values are corrupting the xlsm file. In the code example below, the xlsm file is corrupted but the xlsx file works well When I open the…
SiddSaid
  • 1
  • 3
0
votes
1 answer

Read closed .xlsm files as xml files to pull data

I am a new programmer and I am trying to find a way to extract one range of data from multiple workbooks and copy them into a master file. I have already wrote the code to do this below, but the problem that I am having is that my code physically…
Hasib Ibradzic
  • 29
  • 1
  • 12
0
votes
1 answer

Loop through XLSM files SSIS 2012

I have a bunch of Macro-enabled Excel Files. I want to loop through each one of them with a SQL Query - select * from [Sheet1$A10:AZ100]. My Excel Connection Manager works when I have selected one file however there is a big problem when I add a For…
CuriousBeing
  • 1,592
  • 14
  • 34
0
votes
1 answer

Excel Macro VBA- How to save as xlsm with a filename based on date and cell value

I really liked the solution here that provided VBA that to force save as an xlsm file. Keeping in mind that I barely know anything about VBA, how could I modify this code to do the following: continue to force save as xlsm file name equals the…
David W Harrington
  • 1
  • 1
  • 1
0
votes
3 answers

workbook_beforesave event not firing

I have a VBA Code which forced the save as dialog box to show the default save as type as xlsm while trying to save a xltm. Please check out the attached code and correct me if code is incorrect Application.EnableEvents = False…
Maya
  • 27
  • 4
  • 11
0
votes
0 answers

File size grows after running sub

I'm working on a calendar and am trying to create a sub that automatically fills in each of the weeks in the year in the corresponding month-sheet. The week format and content is copied by firstRange.Copy Destination:=secondRange from a hidden…
swit
  • 187
  • 3
  • 14
0
votes
1 answer

open and save a xltm file

I've used some code in VBScript to open a .xlsm file and save that file. Now I want to do the same thing as a .xltm file. I've tried to open the xltm file with script, it works fine. While saving that file, it refers the default location and default…
Maya
  • 27
  • 4
  • 11
0
votes
0 answers

Copy data's from one workbook to another workbook through Command Line

I would like to copy data from Excel(xlsx) to macro enabled file(xlsm) through command prompt. I have used the following syntax copy sourcefile destinationfile Above command works fine for two xlsx or two xlsm files. If I try to copy from xlsx to…
Maya
  • 27
  • 4
  • 11
0
votes
0 answers

Fetch values from Excel files and put into database

I have to map Excel files into database values. Given that the Excel files have a lot of rows I'm using https://github.com/monitorjbl/excel-streaming-reader because otherwise, with Apache POI, I receive memory error. This is the old code that…
luca
  • 3,248
  • 10
  • 66
  • 145
1 2 3
…
17 18