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

Excel Add-in Manifest: Where To Specify Minimum Required API

According to Microsoft's Office add-in documentation. the Requirements element in the manifest specifies "... the minimum set of JavaScript API for Office requirements that your Office Add-in needs to activate." I can't figure out the correct place…
MonkeyWithDarts
  • 755
  • 1
  • 7
  • 17
3
votes
1 answer

Deploying Excel DNA Application

I am a newbie to using Excel DNA so please pardon if the question is off. I have an ExcelDNA project that I am trying to find the steps on how to publish and deploy on the user's machine. The Application is written in c# using vs2017 and is a class…
JoeyDiaz
  • 137
  • 1
  • 2
  • 12
3
votes
2 answers

Excel DNA and Excel Add In COM

I have had previous experience working with an Excel Add-In vsto COM object. Specifically using the Excel.Interop dll to create a worksheet and populate it with data. As well as, interact with the worksheet by using the worksheet change events to…
JoeyDiaz
  • 137
  • 1
  • 2
  • 12
3
votes
2 answers

Convert Document.getFileAsync data to FormData for Office file uploading

I'm working on Office Add-in project, I need to get current Office file and upload to our server. Below is upload file from File Browser to our server var fdata = new FormData(); fdata.append('data', file); fdata.append('totalFileSizeBytes',…
Mục Đồng
  • 216
  • 1
  • 12
3
votes
2 answers

Distributing macro as an Add-In to other users

I am looking for some tips how to resolve a problem with distributing macro to other users in my company. I’ve created a specific workbook which holds a bunch of various types of data such as dates, strings and numbers. Each of the users have to…
tomek198823
  • 115
  • 2
  • 11
3
votes
2 answers

Installation Folder URL in Click Once Publish Window - VSTO

What will do the Installation Folder URL will do while publishing the application? I read so many articles got confused.
Rama Krishna
  • 645
  • 10
  • 28
3
votes
1 answer

Release COM when developing an Excel Addin?

I understand that I should release COM objects when using interop. Are things a bit different when developing and Add-In, Excel for example? Here is a loop I have and I was curious to know if the Marshal.ReleaseComObject is necessary? foreach…
xaisoft
  • 3,343
  • 8
  • 44
  • 72
3
votes
0 answers

What Cryptography Provider Types can Sign a Clickonce Manifest

I have a self-sign certificate for signing an Excel add-in deployment manifest. The add-in will be used on our internal network only so there is no need to pay for a third party one. When I try to build the project (Excel 2013 VSTO add-in project…
Owen Smith
  • 63
  • 6
3
votes
1 answer

We couldn't connect to the catalog server for this add-n

I just realized that many add-ins cannot be loaded in Excel Online (Chrome): Does anyone know what's happening?
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
3
votes
1 answer

How can I get all Excel ribbons tab ids and labels?

I am working on an Excel add-in tool with a custom ribbon implementation. For this I need to find existing Excel ribbon tab ids and labels in Excel. How can I do this in C#?
Rohit
  • 31
  • 1
3
votes
2 answers

Creating PowerShell Automatic Variables from C#

I trying to make automatic variables available to Excel VBA (like ActiveSheet or ActiveCell) also available to PowerShell as 'automatic variables'. PowerShell engine is hosted in an Excel VSTO add-in and Excel.Application is available to it as…
Uros Calakovic
3
votes
2 answers

How to get User Defined Functions in Excel Add-Ins (Excel 2007) to work with AutoComplete?

I have created an Add-In and when I go to use it in the expressions box the autocomplete doesn't work. I do see them when I click the functions 'f' button under user defined functions. I would just like the AutoComplete to work with them so I don't…
Mike Cheel
  • 12,626
  • 10
  • 72
  • 101
3
votes
1 answer

Which version of the Excel API should be referenced in the manifest file, when submitting add-in for the Office Store?

When submitting Excel add-in to the office store. Which version of the Excel API should be referenced in the manifest file? We have experienced being rejected because we didn’t refer to the newest version of the Excel API. But if our Excel add-in…
Jacob-T
  • 31
  • 2
3
votes
1 answer

Inserting column in Excel 2013 Add In fails with Error 438

I would appreciate help solving this vexing problem with inserting a column into a worksheet with VBA. The worksheet is generated from a database. I need to insert a column into the worksheet for data that is not part of the database. The project…
PFunk
  • 31
  • 4
3
votes
2 answers

How to Identify an Office 365 User Account from inside an Excel Add in

I would like to understand if there is any API which can help us find the Office 365 user account information from my Excel add-in javascript code. Eg- Let's assume a user with Office email account abc@xyz.com launches Excel, downloads my add-in…
user5501201
  • 245
  • 3
  • 10
1 2 3
…
85 86