Top "Excel-addins" questions

Excel add-ins are self-contained programs that extend or add functionality to Microsoft Office Excel.

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 …

c# oracle excel-addins
Change the pivot Table filter using VBA

I have a pivot table which contains the "CoB Date" field as shown. I am trying to create a macro …

vba excel excel-addins
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 …

excel excel-addins
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 …

excel vba excel-addins
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 …

c# vsto excel-addins rtd excel-udf
How do I enable an Excel Automation Add-in through the registry?

I have an Excel Automation Add-in that is registered with COM by my installer. By registering with COM, my add-in …

excel registry excel-addins rtd vba
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 …

c# multithreading com timer excel-addins
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 …

excel excel-2010 excel-addins exceldatareader vba
Trim all cells within a workbook(VBA)

I have attempted to add functionality to an excel add-in ave been developing which trims the leading spaces at the …

excel excel-addins vba
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, …

excel excel-addins vba