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

*.xlam add-in and missing references in a new VBA project / new Excel's instance with the add-in turned on

Repro: Start Excel and open VBE ALT+F11. Find Tools and click References. Scroll down til you find Microsoft Scripting Runtime and tick it. Save the file as Addin.xlam in the default location which should be something…
user2140173
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
  • 699
  • 7
  • 33
5
votes
1 answer

Is any way to add the changes to undo/redo stack made by Excel addin?

Here I am using Office.js API in Excel add-in. When I export any table or information using Excel add-in, the undo and redo buttons are disabled, and the undo/redo stack is cleared. Thank you in advance
Rajat Panjavani
  • 65
  • 4
5
votes
0 answers

Functional tests for office-js Excel addin (Selenium?)

We develop office-js based addin for Excel and we've come to a place where we want to write automated functional tests (preferably with Selenium) for desktop version of Excel on Windows. First issue we've encountered was that different combinations…
mich
  • 96
  • 3
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…
Tsiry Rakotonirina
  • 731
  • 4
  • 13
5
votes
6 answers

Error: "Sorry, we couldn't find . Is it possible it was moved, renamed or deleted"?

When opening Excel it looks for an add-in that I have removed from the file folder. It gives me the message that it can't find it, of course, as stated in the title. When I go into Options -> Add-ins -> Go -> Uncheck and click "OK" it is removed…
BlackBear
  • 385
  • 1
  • 5
  • 25
5
votes
1 answer

ADD-IN ERROR This add-in could not be started

Using the Visual Studio 2017 C# Excel 2016/2019 Web Add-In template, I'm trying to create a Basic Add-in to "Insert content into Excel spreadsheets [VS option for project]." All my attempts fail in Excel when I run the project with the message:…
SamG
  • 815
  • 8
  • 12
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
  • 449
  • 2
  • 14
5
votes
1 answer

Where is an Excel Add-In saved when programmatically adding and installing it?

Im trying to automate adding & installing an Add-In for Excel where the Add-In is located on a shared network drive. I know from my reading around the web (here and here) that I need to make the copy that's on the shared network drive Read-Only. And…
CaffeinatedMike
  • 1,537
  • 2
  • 25
  • 57
5
votes
3 answers

Call Excel Add-In function in macro

I am developing Add-in for Excel 2013 and I have created a function in Excel Add-In as below public string ExcelReturnString() { return "This is the string: hi"; } I have used below code to call the function, but it throws an…
User5590
  • 1,383
  • 6
  • 26
  • 61
5
votes
1 answer

How to keep reference to add-in UDF when workbook moved to different folder than add-in?

I wrote an Excel add-in that provides UDFs (user-defined worksheet functions). All is well until one user sends his workbook using those functions to another user, or just tries to use the workbook on more than one computer, where the add-in has…
Greg Lovern
  • 958
  • 4
  • 18
  • 36
5
votes
3 answers

WPF window throws TypeInitializationException at start up

I have an Excel AddIn with several ribbons, one ribbon is setting window. When it is clicked, a custom window will show up. However, there is nothing to show up when clicked. I saw the following exceptions in log file. What causes this and how…
toosensitive
  • 2,335
  • 7
  • 46
  • 88
4
votes
0 answers

Is there a way to open a linked workbook in Excel using Office.js?

I am trying to programmatically open a linked workbook referenced in the current workbook in Excel using the Office.js framework. I see an Excel.LinkedWorkbook class but with no function to open the linked workbook. How would I do this?
Harsh Patel
  • 151
  • 6
4
votes
0 answers

How to configure karma and jasmine for Office Addin

I am trying to configure karma and jasmine for Office Excel AddIn. I have configuration like below: // Karma configuration // Generated on Fri Nov 26 2021 11:34:29 GMT+0800 (China Standard Time) module.exports = function(config) { config.set({ …
Edward
  • 28,296
  • 11
  • 76
  • 121
4
votes
0 answers

OSF.DDA 7000 Excel office js Dialog API error

My taskpane is on URL https://presimax.in/testhome And dialog box is on https://presimax.in/word Here is the code for dialog box,
bhavasagar
  • 91
  • 6
1 2
3
…
85 86