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

VBA Save (Add) Data Duplicate Items on ListBox, but only Save One (as it should)

I'm trying to develop a plan, and when I'm saving a item, the listbox add the new item, but duplicates the other data aready saved, duplicating the itens. Salve code: Private Sub btnSalvar_Click() If txtReceita.Value = "" Then MsgBox ("Insira o…
Martha Andrade
  • 11
  • 6
-1
votes
1 answer

Change rows color

I have an excel file and i need to check the column B for a certain range (for example range: 1:3000) and if is present a value different from "new" and empty cell so i need to change the row color in grey from column B to O. Like this: How can i…
Stefano Brunato
  • 29
  • 6
-1
votes
1 answer

Is there way faster way to edit xlsm file other than openpyxl?

file='excel.xlsm' wb=openpyxl.load_workbook(filename=file, read_only=False, keep_vba=True) sheet=wb['Template'] rowx=['x','y','z'] rows=sheet.max_row sheet.cell(row=rows+1, column=j+1).value=row[j] wb.save(file) I have an xlsm file and I have tried…
Sai Ram
  • 1
-1
votes
1 answer

How to open a protected Excel File with ClosedXML?

Is it possible to use ClosedXML to open an Excel file protected with a password? And if so, how? I tried using Interop but it's very slow. Using Interop.Excel Microsoft.Office.Interop.Excel.Application wb = xlApp.Workbooks.Open(Filename:…
user2988717
  • 127
  • 3
  • 8
-1
votes
1 answer

How do I add rows/columns to an existing xlsm file in Rails?

I have an existing .xlsm file in my application. I have to be able to edit it. I mean I want to add rows/columns to it. How do I do it? What are the possible solutions? I have just started learning Rails, so I am unfamiliar with most of the things.
mehtasuraj09
  • 139
  • 12
-1
votes
1 answer

Writing a string to .xlsm file

wef : write to xlsm (Excel 2007) using apache poi When i write a simple string to the file, I am not able to open the file. Error - "Excel cannot open the file 'Test1.xlsm' because the file format or file extension is not valid" try { Workbook…
user1454829
  • 79
  • 1
  • 2
  • 7
-1
votes
1 answer

java heap space while writing 86000 rows with .xlsm excel using xssf

java heap space raised while writing 86000 rows with .xlsm excel using poi xssfworkbook at hhhhCell = hhhhRow.createCell(j + colNumber); hhhhCell.setCellValue(ret.getFieldValueString(sortSequence.get(i), colName)); java.lang.OutOfMemoryError: Java…
Dinanath Parit
  • 165
  • 3
  • 4
-1
votes
1 answer

Transferring Search Box From Old Page to New Design (From Scratch)

I am a computer science major and relatively experienced front-end developer (HTML, CSS, Javascript, as well as some development history with PHP, Java, Ruby and Linux Command Line). Recently I signed on with a team that is doing some webpage…
Machgogogo
  • 5
  • 2
-2
votes
1 answer

How can I minimize this code? because excel said it has more than 64 conditions

note: those texts equivalent to $C$1 is a dropdown list. =IF( $C$1="", "", IF( $C$1="AGLAYAN 1", T4, IF( $C$1="AGLAYAN 2", AI4, IF( $C$1="ALABEL", AX4, IF( $C$1="BABAK 1",BM4,IF($C$1="BABAK…
Ritchie Quijano Arconila
  • 1
  • 2
-2
votes
2 answers

Error adding a new sheet to a XLSM Macro Enabled Excel File

I want to add a new sheet in a Macro Enabled Excel File using VBA. It doesn't matter the method that I use: Sheets.add Copying and pasting a sheet to create a new one The new sheet is created (or copied) but the macro stops immediately, without…
aacc
  • 1
  • 4
-2
votes
1 answer

html page with xlsm file as backend

I was wondering whether is that possible to have xlsm file as backend while having html as frontend? How can I achieve this if yes? Thanks in advance.
klpw
  • 7
  • 1
  • 5
-3
votes
1 answer

How to extract the first occurrence of a word (date) from a particular line?

I would like to loop through a column and extract the date and time from the first occurrence of a sales comment to the neighbouring cell. There could be a variable amount of lines in the cell and multiple entries from Sales, I need the first…
NoScreenNames
  • 1
-3
votes
1 answer

extract vba binary from xlsm

i've just started to work with excel macros, and i have a few questions : i've created an excel macro and assigned it to an xls file (created a button and assign it the macro) . Does this make it an xlsm file ? if so, i need assistance to…
Shani Smadja
  • 11
  • 3
-5
votes
1 answer

Excel:VBA code to Loop through combo box list and generate PDF for each.

I'm trying to create VBA code that selects each name one by one in a ComboBox on my worksheet. The linked Cell to the ComboBox is "D5"(which are employee names). However the ComboBox range where the names(about 1700 names) are located is on another…
Sapphire
  • 7
  • 3
-5
votes
1 answer

Copy and paste values only from multiple workbooks on a apecific worksheet in each workbook into one sheet in Excel

I am trying to copy and paste values only, from a specific range from multiple workbooks located in one folder that all has a worksheet named "summary". The code below I'm using Pastes the formatting and all, I only want to paste values. This is my…
Sapphire
  • 7
  • 3
1 2 3
…
17
18