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

How do I enable an Excel Automation Add-in through the registry?

I have an Excel Automation Add-in that is registered with COM by my installer. By registering with COM, my add-in appears in the (for Excel 2007) Excel Options > Add-Ins > Manage Excel Add-Ins Go... > Automation list. The users must still navigate…
Frank
  • 3,029
  • 5
  • 34
  • 43
4
votes
1 answer

Save functionality in Excel Addin using OfficeJs and ReactJS

Background: I am developing an excel Add-in using OfficeJS library. The addin is using the ReactJS components and Office Fabric UI. The Add-in is successfully created and using OfficeJS library we can bring the user selection to the Excel…
Rahul Tripathi
  • 168,305
  • 31
  • 280
  • 331
4
votes
3 answers

Is there a simple "hello world" sample Office 365 Excel add-in guide?

Is there a simple "hello world" sample for coding an Office 365 Excel add-in that I can follow and customize?
user3342423
  • 43
  • 3
4
votes
1 answer

Problem with names collection of worksheet object

I have encountered a problem with OfficeScript (I think). I wrote this script: async function main(context: Excel.RequestContext) { var RowCt = 0; var sheetName = ""; let workbook = context.workbook; let worksheets = workbook.worksheets; …
jkpieterse
  • 2,727
  • 1
  • 9
  • 18
4
votes
3 answers

Is there a Collection of icons used for imageMso?

I started to write an add-in for searching and viewing built in icons/images (imageMso) for the Office Fluent ribbon to find something suitable to add to new buttons. Yes, I know there are many out there, but I haven't found any particularly useful…
Josh
  • 236
  • 1
  • 2
  • 12
4
votes
3 answers

Looking for free way to develop Excel add-ins using IronPython?

I don't know much about VSTO or VSTA, but I think you need the full version of Visual Studio to use either one. I can't convince my boss to buy us this, but I would like to develop Excel addins in IronPython. I've looked at several tutorials that…
oob
  • 1,948
  • 3
  • 26
  • 48
4
votes
2 answers

Excel Addin that works on Excel 2007 and 2010

I'm writing an Excel Addin that should work in both 2007 and 2010. When I create a new project with Visual Studio I need to decide which version I want. I've chosen 2007 before, but since I have 2010 installed I can't debug it. I get an error: You…
Jonas Stawski
  • 6,682
  • 6
  • 61
  • 106
4
votes
1 answer

Need to find the name of the current file in excel addin

I have an excel addin for 2003 excel. This add in adds a menu command to the excel menu. what my requirement is that, when I click on this menu command I need to send the name of the current file to a different process... how do I obtain this…
Sandepku
  • 861
  • 14
  • 31
4
votes
1 answer

Register UDF with descriptions of arguments using excel addin

I have an addin with an UDF getRegExResult. I want to add a function description and arguments descriptions to this function, so when user installs the addin, closes, opens excel few times and goes to "Insert Function" Dialog box he will be able to…
kolcinx
  • 2,183
  • 1
  • 15
  • 38
4
votes
4 answers

When to set MacroOptions for Excel Addin

I'm making an Excel addin. It consists of a few functions in a module like this: Public Function MyFunctionOne(X As Range, Y As Double) As Double MyFunctionOne = 1 'Example End Function Public Function MyFunctionTwo(X As Range, Y As Double) As…
carole1
  • 55
  • 6
4
votes
1 answer

Build an add-in and UDF for all the Excel versions

One data provider wants to develop an Excel add-in, these are the requirements: 1) it can be installed on desktop. It adds one menu and buttons in Ribbon, and it also provides some specific functions (to get real-time data, like Bloomberg…
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
4
votes
2 answers

Office 2016 share button IdMso

I'm trying to disable the new share button on the top right corner of the Office 2016 apps. Does anyone know the correspondent IdMso? I've tried to locate the IdMso tables but I only find tables for the previous versions of Office.
RicardoSBA
  • 785
  • 1
  • 6
  • 18
4
votes
2 answers

How to copy range formatting in office.js?

Tried the following code that I pieced together from various sources but it doesn't seem to be working. Do I need to go through each individual property and assign them one by one? Excel.run(function (ctx) { var worksheet =…
Mr1159pm
  • 774
  • 1
  • 10
  • 21
4
votes
2 answers

Writing VBA procedure/function to an .xlam addin

I have created a VBA project in Excel and within said project is a module that writes code to another module. I eventually password protected the project so as to keep the code hidden (not realizing right away that this would pose some pretty…
Singularity20XX
  • 321
  • 5
  • 20
4
votes
2 answers

VSTO Installable or exe

I have created a Excel Add in Application and i have built an .VSTO file out of it. Now whether i need to create installer for installing it or is there is any we can create .exe file (without installer). I don't want the installer option as some of…
Frontend developer
  • 469
  • 1
  • 6
  • 18
1 2 3
…
85 86