FAQ Database Discussion Community


Excel Automation Addin - functions not working

vb.net,excel,excel-addins,office-automation
Edit: The real solution to what I wanted to do can be found on this post here. I just wanted to expose some compiled functions to excel. This proved to be very easy using the Excel DNA nuget package. You just add a class library, add the nuget package, and...

Releasing Excel COM objects

c#,com-interop,excel-addins,excel-automation
I have some Excel automation code that uses Excel COM objects. From other SO posts I know that one should do the following to release objects at the earliest convenience: Excel.Range rng = GetSomeRange(); // do something with rng... Marshal.ReleaseComObject(rng); However, if I loop through cells in a range, is...

Excel DNA Function stops working after parameter change

c#,excel,excel-addins,excel-dna
We have a working application that runs using C# and Excel DNA to create functions that access a Java Webservice at a remote location (using RTD Server). This application worked fine until we added optional parameters to one of our functions (I do not really know if the problem is...

Add-In XML script keeps disappearing after save

xml,excel,user-interface,excel-vba,excel-addins
I am using the UI Custom Editor to write xml to create a custom ribbon for Excel. It was working fine; however, suddenly the custom tab disappeared from excel and after checking the script in the editor, I noticed it disappeared. I tried to reinsert the script and save it,...

Publishing Outlook/Excel add to the office store

ms-office,outlook-addin,publishing,excel-addins,office-addins
I have developed an outlook add-in and an excel add-in and created there respective installers. Now I want to publish these installers to the Microsoft office store(https://store.office.com/). Can anyone provide me the steps to do that?...

Strange number-of-character-in-a-cell limitation when programmaticaly (VBA, C#) set array string to a range

excel,vba,excel-vba,excel-2007,excel-addins
I have run into an issue in Excel 2007 which is very similar to a known problem of Excel 2003 described by Microsoft Support here ("You may receive a "Run-time error 1004" error message when you programmatically set a large array string to a range in Excel 2003"). The problem...

Deducing column from User defined range in Excel VBA

excel,excel-vba,excel-addins
Edit: @TimWilliams I edited the code as follows but it it doesn't run at all now. ANy thoughts? Sub Item_Fix() Dim rng As Range, col As Range, arr Dim sht As Worksheet, c As Range, tmp On Error Resume Next 'in case user cancels Set rng = Application.InputBox( _ Prompt:="Please...