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

Run code once add-ins have finished loading

I have code under workbook_open procedure. At the beginning of this code a userform (loading screen) initiates whilst the remainder of the code runs to hide/unhide sheets for the respective user. The userform closes at the end of this code however,…
HarryY
  • 3
  • 2
-1
votes
1 answer

How to Programatically Enable Non XLSM/XLAM/COM Excel Addin?

A bit of context. I have 4 addins that I've created which are used internally on our team. They share a ribbon namespace so they can interact with each other on the custom ribbons. It works pretty well for my level of knowledge. They are XLAM…
Peter
  • 1
-1
votes
1 answer

Can Excel accept a callback from a Web API with a javascript Office Add-in with a Websocket?

I've been asked to call a certain Web API from Excel VBA to do a certain task. I was given a sample call to work with. This is for a propietary Web API for the organization so I don't think it's going to help to post the code here. I was getting an…
Greg Lovern
  • 958
  • 4
  • 18
  • 36
-1
votes
1 answer

How to create/read/delete a "very hidden" named item (Excel Office JS)

Is it possible to create, read or delete a hidden named item in the Name Manager in Excel using Excel Office JS? I am aware that it is possible to create a very hidden sheet, so I am wondering if the same thing is possible with named items.
Marko Cubic
  • 11
  • 4
-1
votes
1 answer

Function ...Workbooks.Open() is failed while opening .xla and .xla addins of excel through c# - HRESULT: 0x80010105 (RPC_E_SERVERFAULT)

I wrote a code in c# in Visual studio and I open excels, run macro and close the excel I do it in cycles (in a loop and delay between every cycle) sometimes the function failes and sometimes it works The error message I got: "The server threw an…
Reut Yfrach
  • 9
  • 2
-1
votes
2 answers

How to use Microsoft add-in in google sheet

I have created an add-in for excel. It's working fine for excel sheet. I want to use my add-ins in google sheet. I am not getting any idea about how to use add-in into google sheet. Can anyone tell me that how to use add-in in google sheet. If any…
Shiv Yadav
  • 467
  • 2
  • 11
-1
votes
1 answer

Excel COM add-in for Training The Street no longer loads after another add-in is uninstalled, reinstalling does not work

My TTS Turbo Macro Excel COM add-in was working before I uninstalled Logi Options Plus for the second time. I tried cleaning up related registry items and reinstalling TTS Turbo Macro add-in and Logi Options Plus but it didn’t help. The load…
stack_potato
  • 1
-1
votes
1 answer

Office.addin.hide APIis not working for Excel and powerpoint Add-ins

I have followed the article . https://learn.microsoft.com/en-us/office/dev/add-ins/develop/show-hide-add-in When calling API Office.addin.hide() it gives below exception for Excel and PowerPoint . RichApi.Error: Sys.InvalidOperationException: The…
Prithavi raj
  • 1
  • 3
-1
votes
1 answer

How to unhide the excel rows, without expanding grouped rows in excel?

I'm working on react excel add-in and have a requirement to unhide the hidden rows. this is working fine with range.rowHidden=false. but the problem here is that grouped rows also expand. How to fix this issue? Any kind of help much be is…
Rajath
  • 2,611
  • 8
  • 27
  • 43
-1
votes
1 answer

Change functionality of Microsoft officejs

I have developed an Excel add-in project. I want to change some actions in my Excel add-in. I would like to restrict users from being able to resize the add-in task pane. I would like to remove the personality menu from my add-in. It is possible to…
Shiv Yadav
  • 467
  • 2
  • 11
-1
votes
1 answer

Excel Javascript Office JS Task Pane: Create Table and Dynamic refresh the table data on Refresh All/Next Time load

i have created the Excel table called 'subjectHubTable', where the data came ti this EXCEL context through a API endpoint. const addSubjectIntoSheet = async () => { const allSubjects = await hubReportService.getAllSubjects(); const…
Arun N
  • 1
  • 1
-1
votes
1 answer

Creating Custom tab in Excel by JavaScript (json format)

Office.onReady(async() => { // If needed, Office.js is ready to be called const contextualTabJSON = `{ "actions": [ { "id": "executeWriteData", "type": "ExecuteFunction", "functionName": "writeData" } …
Vikash Choudhary
  • 125
  • 7
-1
votes
1 answer

Excel Custom Function in reactjs

I want to create a excel custom function in reactjs. I am not getting any idea about it. If any one have idea about custom function in reactjs. plz share that. if anyone have any documentation link plz share that. Plz share any github link of…
Shiv Yadav
  • 467
  • 2
  • 11
-1
votes
1 answer

VBA Add-Ins Question

I want to run my code when add-in loads. (Open excel file -> load addin -> run code) But I have a problem with event handler. I don't know what kind of event handler I need use and how to load installed addin. (I try to use Workbook_open handler but…
Expert wanna be
  • 10,218
  • 26
  • 105
  • 158
-1
votes
1 answer

Is there a way to get selected worksheets?

In the Office-JS library, it is possible to get all the worksheets in a workbook. It is also possible to get one specific worksheet. Is it possible to get the selected worksheets in a workbook?
Sam Diaz
  • 51
  • 4
1 2 3
…
85 86