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:

974 questions
8
votes
3 answers

WPF new window creation on new thread error

void itemCommand_Click(Office.CommandBarButton Ctrl, ref bool CancelDefault) { var thread = new Thread(() => { if (LoginCheck()) { ItemWindow itw = new ItemWindow(); …
icewall
  • 101
  • 6
7
votes
1 answer

Excel Javascript Add-in: how to open ExecuteFunction in the taskpane rather than new iframe?

I'm trying to use the Excel Javascript API to create an addin that: Adds multiple buttons on the Home tab. Each of the buttons opens the taskpane to a different screen. Each of these taskpanes runs in the same runtime (e.g. I can share data…
Nate Rush
  • 241
  • 1
  • 11
7
votes
2 answers

How to troubleshoot why Excel disables an add-in?

I've written an Microsoft Excel add-in in .NET using Add-in Express, and deployed it to about 50 different user sites, all running Office 2003 on Windows XP. The add-in works fine at the majority of sites, but in a few cases, Excel seems to disable…
David Korn
  • 991
  • 4
  • 10
  • 18
7
votes
2 answers

Change the pivot Table filter using VBA

I have a pivot table which contains the "CoB Date" field as shown. I am trying to create a macro which automatically changes the date as per the user input. I've written the following macro code. But it shows the error: Unable to get PivotFields…
pikachuchameleon
  • 637
  • 2
  • 7
  • 25
6
votes
2 answers

Optional Argument of COM Add-in vs Automation Add-in Written in C#

I am working on a library of COM Add-in and Excel Automation Add-in, whose core codes are written in C#. I'd like to set an optional argument for the function and I know that this is legal for both C# and VBA, and even Excel WorksheetFunction. But I…
Yang Wang
  • 145
  • 5
6
votes
1 answer

Excel Add In - Where does console.log output it's message - NodeJS

I am trying to create an Excel AddIn with JavaScript API. But I don't understand where "console.log" outputs their messages. All Microsoft documentations are full with console.log examples, but it is not explained where console.log() outputs the…
csskevin
  • 348
  • 2
  • 10
6
votes
1 answer

Excel Add-ins installed programmatically are not loaded

Question Summary: Why do my add-ins which are installed programmatically do not load when I start Excel from Program Menu but are loaded when I open the Installer.xlsm workbook which installed them? Details: My team develops a hierarchy of add-ins…
Tamara Aviv
  • 825
  • 1
  • 11
  • 26
6
votes
2 answers

How to reuse Core VBA functions (UDFs) across projects, but not show them in cell insert function

I have an Addin with "core" functions and subs that I want to reference and use in different Addins or VBA projects. Because of the code reuse and single update principles. For example, a function, that filters collection members based on criteria…
kolcinx
  • 2,133
  • 1
  • 12
  • 34
6
votes
1 answer

Deploying Excel Add-In using NSIS - Registry issue

I created a test project in VS 2012 file -> new -> project -> Other Languages -> Visual C# -> Office -> 2010 which builds fine. I would like to deploy this on client machines, looking on the MSDN website I have 2 options, clickonce or…
cool mr croc
  • 743
  • 1
  • 13
  • 31
6
votes
9 answers

Excel Custom Task Pane not showing

I'm showing a custom task pane in an excel VSTO add-in, I'm building it and showing it as thus: var ctrl = new CellTaskPane(); var pane = CustomTaskPanes.Add(ctrl, "Custom Sheet"); pane.DockPosition =…
Clint
  • 5,733
  • 2
  • 23
  • 44
6
votes
3 answers

VSTO Debug version fine, Installed version doesn't read app.config

I have a VSTO Excel 2007 add-in that should read connectionstrings from the app.config file, and then let the user decide which database to connect to. This works fine when I debug it, but when I run the deployed version (done with Windows…
Igavshne
  • 661
  • 6
  • 29
5
votes
1 answer

C# Visual Studio Excel Add-in: How can I detect Excel Office Theme Change?

I wrote a class that detects what is the current Excel theme. Get Excel current office theme: //Declaration string officeVersion; int themeCode; // Get Office Version first officeVersion = "16.0"; // Goto the Registry Current Version RegistryKey…
Tsiriniaina Rakotonirina
  • 711
  • 4
  • 12
5
votes
3 answers

Remove/Update Excel Add-In Sideloaded via Shared Catalog

I am developing/testing an Excel Add-In. I added it to the desktop version using the "shared folder catalog" process outlined…
Sam B
  • 177
  • 11
5
votes
1 answer

Why created name range not able to get named item range?

I tried to read range from named item in workbook, but getting an error: This operation is not permitted for the current object. First of all created name range(using add() method on names object). Excel.run(function (ctx) { var sheet =…
Pavan Divekar
  • 439
  • 2
  • 11
5
votes
2 answers

Programmatically Save Excel Add-In

I have a worksheet updated occasionally by users that is used to make an Add-In (.XLAM). The Add-In is located on a network share and users link to it. I am looking to enable users to easily update this add-in (ensuring it is marked as read only) I…
Tom
  • 51
  • 1
  • 2
1
2
3
…
64 65