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
0 answers

VSTO Add-In build Error

I try to build my Excel 2007 add-in in Visual Studio 2010 SP1 environment. I had programmed it a few months ago. I have Office 2007 installed. I had the same problem as in this link: Build Error + Creating VSTO addin for excel 2010. After internet…
Demir
  • 1,787
  • 1
  • 29
  • 42
0
votes
1 answer

Macro not in the list after loading the add-in

I have a created a macro show() and saved it as display.xla and open a new workbook and added the display add-in. But when i went to Tools->Macro->Macro.. its not the list, But if i type display.xla!show and click run im able to execute it. Is there…
kurozakura
  • 2,339
  • 8
  • 28
  • 41
0
votes
1 answer

Excel Addin and ASP.net

I want to add functionality with my our website, when you request to change a set of date (Shown in Gridview). that when you click "Edit" that it would open up in Excel. When that is completed and the user made changes he/she should click on a addin…
Donald Jansen
  • 1,937
  • 4
  • 22
  • 41
0
votes
2 answers

Select worksheet in Excel add-in to run VBA macro

I have created an add-in using VBA which is a workbook with calculations. The add-in has a userform to extract relevant information from access database and populates the workbook. After the data is populated, calculations are performed in Sheet1. I…
VBAlearner
  • 31
  • 1
  • 1
  • 6
0
votes
0 answers

How to load an Office add-in already installed from an external program in c#?

I'm developing an add-in for Power Point with VSTO in c#, it's already installed but not loaded on the startup of power point. I whant an external program to lounch Power Point (already solved), and when lounched make Power Point to load the…
PVJ
  • 123
  • 1
  • 8
0
votes
1 answer

pointing to local drive Office.FileDialog fDialog = Application.get_FileDialog(Office.MsoFileDialogType.msoFileDialogSaveAs)

I have created Excel add in project in c# (.net 2010). My project saves excel file to sharepoint.I have used Office.FileDialog fDialog = Application.get_FileDialog(Office.MsoFileDialogType.msoFileDialogSaveAs) I have set fDialog.InitialFileName…
user2630348
  • 1
  • 1
0
votes
1 answer

How can I prevent ClickOnce deployment with VS 2010 Excel Add-In

In the past I have developed Excel Add-Ins using VS 2010. These have all worked fine, but to get them installed I have had to create my own installation packages. No problem. I now have a new PC with VS 2010 installed. So whenever I create a new…
steveo40
  • 931
  • 5
  • 11
0
votes
1 answer

Restrict Excel Add-in Distribution

I have an Excel Add-in that we want to deploy to clients. Currently it is an .xlam file. I know that Excel Add-ins are probably not the best way to distribute software, but that is what I've got. My question is how do I protect this Add-in from…
neelsg
  • 4,802
  • 5
  • 34
  • 58
0
votes
1 answer

Find current column for Excel automation add-in

I am trying to create Excel Automation Add-ins with C# to add new functions to Excel. Like this example: http://blogs.msdn.com/b/eric_carter/archive/2004/12/01/273127.aspx I am quite new to programming such add-ins. One of these functions calculates…
Frode
  • 1
0
votes
1 answer

Excel Add-In warnings

Here are some warnings that I've encountered during making this add-in: Warning 1 Processing COM reference "" from path "C:\Windows\system32\stdole32.tlb". The type library importer could not convert the signature for the member…
Sylca
  • 2,523
  • 4
  • 31
  • 51
0
votes
0 answers

Excel Add In Worksheet.SelectionChange Does Not Fire After Deployment

My Excel Add In hooks into the SelectionChange event of two worksheets. The event fires, and is responded to appropriately, in my development environment. However, once it is deployed to a client machine, the event doesn't trigger. Dev and user…
Michael
  • 1,803
  • 1
  • 17
  • 26
0
votes
0 answers

Under what condition will Excel think an add-in has a serious issue?

I have an Excel XLL AddIn It uses a modal window on two ribbon buttons click handler. When one modal window is on, I right click on the button on the bottom tool bar. Restart Excel, everything is fine my addin has no issue. When the other modal…
toosensitive
  • 2,335
  • 7
  • 46
  • 88
0
votes
2 answers

AddInExpress install error - AddCustomTaskPanes

When I install a AddInExpress addin and open Excel I get this error: Exception Source: Exception Type: System.Runtime.InteropServices.COMException Exception Message: Unable to create specified ActiveX control. Exception Target Site:…
Jeremy Thompson
  • 61,933
  • 36
  • 195
  • 321
0
votes
1 answer

Clear ribbon dropdown C# excel add-in 2010

I try to find solution for my problem. But nothing to find. I have 2 dropdown list and when I change value in first list I want to clear and fill new values new list. Is it possible?
Ray
  • 1,788
  • 7
  • 55
  • 92
0
votes
1 answer

Inserting multiple rows into an Excel Sheet with Vb.Net Com Add-In

After determining a row index for an Excel Worksheet, InsertRow, I would like to insert 16 rows after it using VB.net. I am building a COM add-in if that changes anything. In VBA I would do this via: ... Dim InsertRow as String ... Dim…
Atl LED
  • 656
  • 2
  • 8
  • 31
1 2 3
…
85 86