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

SQL Server excel "data mining" addin error message

I have a problem about using SQLServer "data mining" addin on excel. Below programs installed on my PC: SQLServer 2016 CTP2.0 64bit Office 2013 pro plus 64bit SQLServer 2012 data mining addin 64bit I activated the data mining addin and connected…
kzmlbyrk
  • 583
  • 1
  • 4
  • 17
4
votes
3 answers

Unable to get the Copy property of the Worksheet class

I'm trying to copy a worksheet from workbook into another using Worksheets.Copy function. However, this seem to be working in only some of the files and for others I get "Unable to get the Copy property of the Worksheet class" error message. I've…
DataPispor
  • 381
  • 3
  • 8
4
votes
2 answers

Parsing Large List of Excel Files Failing

This is a C#/VSTO program. I've been working on a data capture project. The scope is basically 'process Excel files sent by a variety of third party companies.' Practically, this mean: Locate columns that contain the data I want through a search…
getglad
  • 2,514
  • 3
  • 24
  • 47
4
votes
3 answers

How do I create an Excel add-in that reads custom data?

I have been tasked with creating an addin for Excel 2007 that reads data from a custom data source. I already have the code that reads the data. It's written in C# and returns objects. This is for a banking system and I cannot give direct access to…
Dan Crowther
  • 495
  • 1
  • 7
  • 11
4
votes
1 answer

Forward Compatibility of Office Addins

I have built an add-in for office 2010 using VS 2010. I have followed these steps to create the msi but when I tried to install it with office 2013 I get an error telling me that: "A required component for interacting with excel is not…
Pat Mustard
  • 1,852
  • 9
  • 31
  • 58
4
votes
3 answers

System.Windows.Forms.Timer not firing

I want to use a System.Windows.Forms.Timer to ensure that an event fires on the UI thread of an excel addin I'm creating. I construct the timer as follows: private System.Windows.Forms.Timer _timer; private void ThisAddIn_Startup(object sender,…
Pat Mustard
  • 1,852
  • 9
  • 31
  • 58
4
votes
3 answers

Build Error + Creating VSTO addin for excel 2010

I try to create an excel add-in using VS 2010. When I create a new project Excel 2010 Addin, and try to compile the solution. I get an error which says. 'Error 1 The "FindRibbons" task could not be loaded from the assembly …
Sandepku
  • 861
  • 14
  • 31
4
votes
1 answer

Wix Toolset: cannot add Excel Add-in project reference

I've just installed latest Wix v3.7. I created a VS 2010 "Excel 2010 Add-in" project and, in the same solution, a Wix "Setup Project". Problem is, when I try to reference the Add-in project from the Wix project, it is not there, I tried a simple…
Ariel
  • 5,752
  • 5
  • 49
  • 59
4
votes
1 answer

register Shortcut-Key only for Excel VSTO

In my VSTO project (for Excel) I want to hook a shortcut-Key (keyboard combination of 3 keys) to a function in my C# code. for example when I press CTRL+SHIFT+C a function MyShortCutFuction should invoked.
KhannaB7
  • 265
  • 5
  • 17
4
votes
1 answer

What's the fastest way to export all excel add-in modules to .bas files?

I'm working on an big excel-addin with many modules. I need to export them to .bas file to manage them with SVN. I know a hot key to export them fast, Ctrl+E. But the number of my modules is too many that I still lose too much time to export…
Davuz
  • 5,040
  • 13
  • 41
  • 61
4
votes
1 answer

Excel AddIn Click Once deployment issue

When I create a Excel 2010 Add-in project in Visual Studio 2010, and configure my prerequisite publish options for click once deployment, the 'Microsoft Visual Studio 2010 Tools for Office Runtime (x86 and x64) option item, has a warning indicator…
mservidio
  • 12,817
  • 9
  • 58
  • 84
3
votes
2 answers

can histogram function in analysis toolpak update results when input data is updated?

I am using histogram and correlation functions in Analysis Toolpak and need the results to be updated as I change my input data or references. Is this possible in some way? thanks
user236215
  • 7,278
  • 23
  • 59
  • 87
3
votes
1 answer

Error: Office.js has not fully loaded. Your app must call "Office.onReady()" as part of it's loading sequence

I have created an Excel add-in using the Office JS library. My add-in works fine with Office 365 but when try to run the same add-in with Office 2019 or 2016 it shows a blank screen only and throws error : Office.js has not fully loaded. Your app…
Poojan3037
  • 310
  • 1
  • 9
3
votes
0 answers

Worksheet Id changes after reopening excel sheet in Office 2016 version

I have created an excel add-in using Office JS API and I am storing my worksheet's metadata with the worksheet id. When I save my worksheet at that time my worksheet id is "{4BBBF664-CB10-44A3-9B15-B13CBACC4D9A}". But when I reopen the Excel sheet…
Poojan3037
  • 310
  • 1
  • 9
3
votes
0 answers

Raise an Event within an Excel-Addin when a Userform is loaded by the Excel Application or other Addin

I need to detect from within an excel-addin when a userform is loaded into memory without using the Initialize- or Activate-event of the loaded userform. I'm currently trying to extend an Excel app by a translation addin to provide for the users a…
Bernd
  • 96
  • 4
1 2 3
…
85 86