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

Calling Sheet from a WorkBook

I'm trying to call the 5th sheet in an open workbook. When I open the workbook from the program I seem to be able to do it: Dim CurrentRun As New Excel.Application Dim CurrentBook As Excel.Workbook Dim CurrentSheet As Excel.Worksheet Private Sub…
Atl LED
  • 656
  • 2
  • 8
  • 31
0
votes
1 answer

CommandBarButton on Context Menu doesn't work after ElementHost becomes visible

I have a CommandBarPopup on a the context menu in excel that contains three CommandBarButtons, one of those buttons opens a web page, the other two open a custom task pane. If I make the custom task pane containing an element host which hosts a WPF…
Eva Lacy
  • 1,257
  • 10
  • 24
0
votes
1 answer

Using Range.TextToColumns to convert to multiple columns does not work

My goal is to convert a single csv string to multiple columns in excel using Range.TextToColumns(). I have a csv file whose columns can contain commas inside them, in that case the column value has double qoutes around it. So to avoid that issue I…
SutharMonil
  • 78
  • 3
  • 19
0
votes
2 answers

How to set Excel footer with Excel-Add-In

I've been told to write up an Excel-Add-In which pastes a specific footer into every worksheet in a workbook. After reading up the documentation of the Excel.Interop namespace I ended up with this junky piece of code: public partial class…
Marco
  • 22,856
  • 9
  • 75
  • 124
0
votes
1 answer

Custom Excel function in C# is always disabled

I am trying to create a custom Excel function in C# (I hope to pull report data from a web API into Excel). However when I go into Excel, I can add the new Automation Addin, but it is listed under "Inactive Application Add-ins", what's going wrong…
Johnathan Sewell
  • 739
  • 10
  • 26
0
votes
0 answers

resolving dependencies of registered instance in Castle Windsor

I wonder if it's possible for Castle container to resolve dependency on instance when it is registered as follows: var inst = Globals.Ribbons.TestRibbon; this.container.Register( Component .For() .Instance(inst) …
Paweł Paluch
  • 147
  • 8
0
votes
1 answer

Set value of cell in add in

I will explain everything that I have found but in short I just want to set the value of cell A1 in code behind. I have tried Create Excel Add-in - get cell value plus other links and all those techniques work only if I run them on a macro but I…
Tono Nam
  • 34,064
  • 78
  • 298
  • 470
0
votes
1 answer

Detect and close all dialogs

I created an add-in in Excel 2010. There are a few buttons in the add-in, each button will display a dialog, so at same time there can be more than one dialog displayed, all modaless (this is part of the requirement not to be modal). Now what I…
ahlun
  • 458
  • 1
  • 6
  • 17
0
votes
3 answers

Refresh external data in Excel 2010 while the file is open in the background but not in use

I am using Excel 2010 to query MS SQL databases and other Excel files to import data. I have set different intervals for each data connection (10 connections). In excel this data is sliced and diced to create meaningful charts which are presented in…
hoz
  • 502
  • 2
  • 9
  • 25
0
votes
1 answer

C# Excel Addin - Alter custom task pane text box from ThisAddIn.cs

Is there a way to access controls from a custom task pane when creating event handlers in the "ThisAddIn.cs" file? I want to allow the user to either enter a cell reference manually, or just click on a cell and have that reference value show up in…
user1711952
  • 93
  • 1
  • 8
0
votes
1 answer

How to load excel macro modules from .bas files using c#?

I'm trying to write an excel add-in that automatically add predefined modules into the active workbook. The "predefined modules" should meet the following two requirements: these modules are exported from excel vba editor, in the .bas format…
lowatt
  • 363
  • 2
  • 18
0
votes
1 answer

How to add an item to the Powerpont context menu using .net add-in project

I've never wrote an office-plugin before, and I'd like to add my-own functionality to Powerpoint. I want to add an item to the context menu that pops-out when the user select a slide, an when this item is selected - i want to launch .net form. I'd…
Uri Goren
  • 13,386
  • 6
  • 58
  • 110
0
votes
1 answer

How to only read cells with values with in a specific range in Excel - using VSTO C#

I am doing an ExcelAddin in VisualStudio 2010 for Excel 2007. In my Excel Workbook I have a named range that I call MyRange. It goes from cells C10 to M25. How can I read only the cells that have value in them within MyRange. Note I don´t want to…
Steini
  • 33
  • 2
  • 7
0
votes
2 answers

How to compile C code for an Excel XLL in Visual Studio 2008 so it runs on Office 2010 64 bit version

I have an Excel add-in that I developed using Excel 2007 SDK, it works fine on Excel 2007 and Excel 2010 32 bit version More recently I noticed that Office 2010 or Excel 2010 is also made available as 64bit software as compared to 32 bit version in…
user676876
0
votes
2 answers

excel 2010 add-in setup project with setup factory

I am developing an excel add-in. I have serial numbers(ex. 100 psc) and I want to check when excel add-in installing on pc. But I cant do it with VS2010 setup project because it is not supporting serial number list storing and checking. so I want to…
Savas Adar
  • 4,083
  • 3
  • 46
  • 54
1 2 3
…
85 86