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
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
  • 3,029
  • 5
  • 34
  • 43
18
votes
3 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,299
  • 3
  • 33
  • 43
13
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,613
  • 6
  • 23
  • 52
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,335
  • 7
  • 46
  • 88
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…
محمد النعيمي
  • 570
  • 2
  • 9
  • 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
  • 34,064
  • 78
  • 298
  • 470
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
  • 325
  • 1
  • 2
  • 15
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,573
  • 3
  • 34
  • 59
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
  • 35,324
  • 3
  • 105
  • 112
9
votes
3 answers

WPF new window creation on new thread error

void itemCommand_Click(Office.CommandBarButton Ctrl, ref bool CancelDefault) { var thread = new Thread(() => { if (LoginCheck()) { ItemWindow itw = new ItemWindow(); …
icewall
  • 111
  • 6
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
2 answers

How to troubleshoot why Excel disables an add-in?

I've written an Microsoft Excel add-in in .NET using Add-in Express, and deployed it to about 50 different user sites, all running Office 2003 on Windows XP. The add-in works fine at the majority of sites, but in a few cases, Excel seems to disable…
David Korn
  • 1,091
  • 4
  • 12
  • 19
8
votes
5 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,715
  • 20
  • 87
  • 134
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
  • 547
  • 1
  • 8
  • 26
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,362
  • 3
  • 19
  • 40
1
2 3
…
85 86