Stack Overflow
Stack Overflow

Questions tagged [excel-addins]

Excel add-ins are self-contained programs that extend or add functionality to Microsoft Office Excel.

Microsoft Office Excel add-ins are self-contained programs that extend or add functionality to Excel. By default add-ins are not enabled, and they need to be installed / activated.

Add-ins can be created in multiple ways

  • .xla: a specially saved workbook containing macros for and earlier.
  • .xlam: a specially saved workbook containing macros for current versions of excel.
  • COM: Custom Component Object Model add-ins written in VB6
  • .xll: A DLL add-in using Excel's C API
  • Managed COM addins using or

Visual Studio provides project templates you can use to create application-level add-ins for Microsoft Excel. You can use add-ins to automate Excel, extend Excel features, or customize the Excel user interface.

Links:

1283 questions
-1
votes
1 answer

Is it possible to load List of values in excel using VSTO web add-ins using office.js

I am developing a excel add-in using office.js, that populates table data in excel sheet. Add-in allows user to update table column details, but I want to display list of reference values rather than free text. Example for scenario is given…
Chandrababu
  • 61
  • 2
  • 9
-1
votes
1 answer

Undo is not working in excel add in with in the used range

I have an excel add-in to collect the data and store it on the server. But if I try to undo any cell value within the excel used range it is not working, but in that same sheet if enter anything in other cells and try to undo it is working fine.…
Fayaz M.D
  • 79
  • 1
  • 10
-1
votes
1 answer

Excel add-in is being shown as a COM add-in

I want to build an excel add-in which is application level. I followed the instructions to create a project on MSDN. I don't want to create a COM add-in, I want an Excel plugin. The plugin we create as .xlam file and code it in VBA. Please suggest…
Keyur Patel
  • 33
  • 6
-1
votes
1 answer

How can I deploy the .dna file from ExcelDna?

I am trying to create an Excel (2007) Add-in that will respond to PivotTable changes, using this code: private void ThisAddIn_Startup(object sender, System.EventArgs e) { Excel.Worksheet sh = this.Application.ActiveSheet; …
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
-1
votes
1 answer

Office 2013 JavaScript API - indexing rows above 32'768 in bindingObj.setFormatsAsync

I'm using bindingObj.setFormatsAsync() but I can't mark rows with index above 32768. I've got big amounts of data (even up to 1 milion) to validate, and I need to mark invalid cells/rows by changing background color or other formating…
MoMi
  • 1
  • 1
-1
votes
1 answer

Excel 2007,2010,2013, 2016 Create Addin Installer with Toolbar button to run macro

I have an excel addin file (.xlam). It contains one funtion & one macro. I want to create installer/uninstaller with home-ribbon button to run my macro. My code works fine but I dont know to to make extra tab visible with a button to run my macro. I…
maninder singh
  • 43
  • 4
-1
votes
1 answer

Exceptions are thrown when launch addin

When I start debugging Excel add in from visual studio, get the following errors A first chance exception of type 'System.NullReferenceException' occurred in PRS.NET.Core.exe A first chance exception of type 'System.InvalidOperationException'…
user3289230
  • 431
  • 2
  • 6
  • 19
-1
votes
1 answer

Visual Studio Tools for Office (VSTO) - Looking for some User Guide

I'm looking for some user guide about Visual Studio Tools for Office (VSTO) specially oriented to Excel Add-ins programming. I have installed Visual Studio 2013 and Microsoft Office 2013 on my computer. Do you know about some user guide, tutorial or…
nightclub
  • 671
  • 2
  • 9
  • 20
-1
votes
1 answer

Handing N/A in Array Formulas

I want to figure out how to handle N/A in formulas that use arrays. I'm using the Bloomberg Data History Add-In BDH to get the latest EX-DIV date. But in cases where there is an N/A in the array, the output is N/A instead of the latest EX-DIV…
ninjagirl
  • 23
  • 2
-1
votes
2 answers

exec a xlam everytime I open an excel file

I have the following peace of code to exec a xlam file when I open the excel file: Sub Auto_Open() Application.OnTime Now + TimeValue("00:00:05"), "readCsv" End Sub Sub readCsv() .... End Sub I add it as Add-ins so every…
Iban Arriola
  • 2,526
  • 9
  • 41
  • 88
-1
votes
1 answer

ByRef argument type mismatch:

ByRef argument type mismatch when running the fileconv.xla add-in in Excel 97. The reason I need this to work is because I need to convert ~100 Lotus 1-2-3 files from wk* to xls. The term highlighted in VBA when I compile is marked by double…
threeleggedrabbit
  • 19
  • 1
  • 1
  • 6
-1
votes
1 answer

How to get a code signing for excel addin exe files on a trial version basis?

I am looking to release an excel addin I built on my website, which the user's will download and install. It also has an auto update feature. My problem is when the auto update feature runs it is not allowed save files to the user's machine because…
SutharMonil
  • 78
  • 3
  • 19
-2
votes
1 answer

Where can I find the Analyze Data button in excel?

I was trying to pull out some sample data in excel from the Home button, and then Analyze Data. I have tried add-ins, but it doesn't appear.
Joby Araullo
  • 1
  • 1
-2
votes
1 answer

Is it possible to use outlook web-addins in VBA macro as an object

I've created a macro in Excel to create and display a new email with the BCC, Subject, and Body fields filled with data from specific cells in the excel worksheet. It's basic and gets the job done. I have a plugin called "Smart Email" added to…
JAmeen
  • 1
  • 1
-2
votes
1 answer

How to get macAddress using reactjs or gettting error in package

I want to use macAddress in reactJS Component. But when I am using the getmac package i am getting error. Can any one help me to do this or refer any documentation about macAddress. [Package Error] [1]: https://i.stack.imgur.com/kV0hr.png
Shiv Yadav
  • 467
  • 2
  • 11
1 2 3
…
85
86