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:

974 questions
26
votes
3 answers

How do I create a real-time Excel automation add-in in C# using RtdServer?

I was tasked with writing a real-time Excel automation add-in in C# using RtdServer for work. I relied heavily on the knowledge that I came across in Stack Overflow. I have decide to express my thanks by writing up a how to document that ties…
Frank
  • 2,759
  • 4
  • 31
  • 43
16
votes
4 answers

Loading addins when Excel is instantiated programmatically

I am trying to create a new instance of Excel using VBA using: Set XlApp = New Excel.Application The problem is that this new instance of Excel doesn't load all the addins that load when I open Excel normally...Is there anything in the Excel…
Jon Fournier
  • 4,089
  • 3
  • 30
  • 41
12
votes
1 answer

Excel Error 406 when using both VBA and ActiveX addins.

My Excel addin (XLL AddIn, call it MyAddIn) is built with C#, ExcelDNA, NetOffice, VS2010. Client has another addin (let's call it B), I guess it is written in VBA. Client says B works fine without MyAddIn. Once MyAddIn is installed, B fails with…
toosensitive
  • 2,129
  • 6
  • 40
  • 80
12
votes
3 answers

this is error ORA-12154: TNS:could not resolve the connect identifier specified?

I've this code : OracleConnection con = new OracleConnection("data source=localhost;user id=fastecit;password=fastecit"); con.Open(); string sql="Select userId from tblusers"; OracleCommand cmd = new OracleCommand(sql, con); OracleDataReader dr…
محمد النعيمي
  • 486
  • 2
  • 7
  • 21
12
votes
4 answers

Add user defined function to Visual Studio Excel Add-in

In visual studio I have an Excel 2010 Add-in project. How can I have that project create the following module: I know I can save that workbook with that module then use it with my add in. It will be nice if I can have my add-in create that…
Tono Nam
  • 29,637
  • 73
  • 252
  • 421
11
votes
1 answer

Excel: require Power Query add-in load from VBA macro

The scenario is a Windows Server 2012 R2, 64 bit; Excel 2010, 32 bit. Many users, just a couple of them have administrative privileges. I installed Power Query from the built-in administrator. Without asking anything, the add-in got installed for…
Enrico
  • 295
  • 1
  • 12
11
votes
2 answers

Invalid Hyperlink: Malformed URI is embedded as a hyperlink in the document

I'm using the OpenXml namespace in my application. I'm using this to read the XML within an Excel file. This works fine with certain excel files but on others I get a run time error saying Invalid Hyperlink: Malformed URI is embedded as a…
Craig Gallagher
  • 1,513
  • 2
  • 17
  • 42
11
votes
4 answers

How to perform .Onkey Event in an Excel Add-In created with Visual Studio 2010?

I am creating an Excel Add-In using Visual Studio 2010. I would like to run some code when users clicks a combination of keys. Here is the code I have got Public Class CC Private Sub ThisAddIn_Startup() Handles Me.Startup EnableShortCut() End…
Kannan Suresh
  • 4,517
  • 3
  • 32
  • 58
10
votes
6 answers

Iterating unregistered add-ins (.xla)

I need help in figuring out how to iterate through currently open Excel add-in files (.xla) that have not been registered in Excel using the Tools > Add-ins menu path. more specifically, I am interested in any workbook that doesn't appear in the…
jevakallio
  • 33,015
  • 3
  • 95
  • 111
9
votes
2 answers

Acces Excel Sheet from Button a Ribbon

Ok, so I got my main AddIn which auto generated (Attachment 1) and there is my Ribbon (Attachment 2) and I want to access the currently active excel sheet from that ribbon. But System.Windows.Forms.Application does not contain a definition for…
Jack W
  • 101
  • 1
  • 3
8
votes
4 answers

Possible to tell which workbook called a function in an Excel Add-In (xla)

I want to write a little logging function in an excel add-in that I will be calling from many different workbooks. I'd like to be able to just call it by passing only the log text, and the log function itself could handle the timestamp,…
tbone
  • 5,397
  • 18
  • 79
  • 121
8
votes
1 answer

Secure VBA Excel Addin Code

I have an Excel addin, developed in VBA, deployed on the network. The addin reads from an Oracle database, and pastes tables in a new worksheet, which will also contain a button (triangle shape) to refresh the table. Everything works great, but I…
Kelaref
  • 408
  • 1
  • 5
  • 23
8
votes
3 answers

Excel formula to check cell contents

I'm trying to create some conditional formatting at runtime (huzzah) for an add-in (double huzzah), and have found that, apparently, some functions cannot be used as they would in a normal worksheet. (I just get an invalid procedure call error 5…
downwitch
  • 1,322
  • 2
  • 19
  • 38
8
votes
2 answers

How to call excel add-ins from python

Is there a way to call Excel add-ins from python? In my company there are several excel add-ins that are available, they usually provide direct access to some database and make additional calculations. What is the best way to call those functions…
Nickpick
  • 4,883
  • 9
  • 45
  • 92
8
votes
1 answer

Excel function throws exception when set by code behind. Works when used in excel

I've defined my own Excel function (called ADXExcelFunctionDeescriptor). The method stub looks like following: public static object ExecuteMyFunction(object values, object tagName) { // Some code here } The method receives an array of double values…
Daniel W.
  • 447
  • 9
  • 28
1
2 3
…
64 65