0
votes
0answers
8 views
VSTO file for unmanaged C++ Excel Add-in
I am building an installer for my unmanaged c++ Excel Add-in (.xll file).
Usually this kind of add-in can be deployed and automatically loaded by excel by adding registry values (OPEN1 -> ...
1
vote
2answers
21 views
Start Excel and load specific addin from another program
I want to run (open) Excel within a C# program and load a specific add-in simultaneously. Is this possible?
The C# program should be a kind of launcher EXE, which opens an own specific Excel solution ...
1
vote
0answers
20 views
VSTO 2012: backward compatibility
Since lately the Visual Studio Tools For Office 2012 (VSTO 2012) are available for download ...
2
votes
1answer
47 views
Is there a reason to not use “1” class with a small VSTO Add-in?
I know that in reality if you make a VSTO project in VS, that you start with several classes auto-generated before you write a line of code. I also understand (I think) the single responsibility ...
0
votes
1answer
27 views
embed a button into an excel chart
Roughly speaking, I want to create a child class from Excel Chart to add the following features into the child:
add a button to the visual appearance of the chart (the button should have a fixed ...
0
votes
1answer
28 views
Small Malfunction, no Exception, when Application.ScreenUpdating = False is used VB.NET
I ran into something I've not seen before, Application.ScreenUpdating = False, causing a sub to slightly misbehave. It doesn't throw an error, but it causes an off by one error in the result when ...
3
votes
4answers
149 views
+150
Simple Example of VSTO Excel using a worksheet as a datasource
I think I'm running into a case of "the easiest answers are the hardest ones to find" and I haven't come across any searches that give this to me in a straightforward way. This is for Excel 2010 and ...
0
votes
0answers
24 views
Error (0x800A03EC) from custom ribbon in .Net “Excel 2010 Add-In”
We have a custom Excel ribbon built to display bespoke applications via Excel. The ribbon is built in C# .Net 3.5 with the project being an Excel Add-In. The error is received when users launch an ...
0
votes
1answer
34 views
Determine if WorkSheet.Name is NOT in Workbook or String is not in Array VB.NET
This seems like such a simple question, but I can't seem to find a good way to do it. I want to check if the name of an Excel Worksheet with an index of 'n' is not in the original set of worksheet ...
0
votes
0answers
21 views
Excel VSTO preventing errors when inserting values
I have an Excel Add-In that writes a dataset table, cell by cell, to the active sheet. The data being inserted is text only, no formulas. I need to massage each cell's value to assure there's no error ...
1
vote
1answer
29 views
VSTO Display Selected Cell Reference in Text Box
I have a Windows Form with a list of values to display each with a corresponding text box that tells the program what cell to display it in. Currently the user inputs a range (ex. "A1", "G6", etc...) ...
0
votes
1answer
319 views
c# excel beforesave thread
I try to create a c# excel 2007 Add-In, and i want to do "faster" the "beforeSave" method.
I simply use a thread (and try the task and task.factory too) but its always say same error.
The code.
...
1
vote
1answer
672 views
My custom Outlook Add-in is causing Excel Save dialog box to hide itself
I have created an Outlook Add-In that adds a button to the ribbon of a new email window, but it's causing a problem.
Here is what happens:
User has Outlook Open.
User opens Excel.
User sends excel ...
6
votes
4answers
4k views
In VSTO Excel, how to detect data in cells?
I was wondering if anyone knew how to quickly detect whether there is data in a given worksheet or not, without actually looping through all of the rows/columns of the worksheet to figure this out.
I ...
1
vote
1answer
2k views
How to tell if Excel Application is in cell-edit mode?
I'm writing an Excel Addin using COM Interop from .net. I have a command that pops up a dialog, and from the dialog I do some work like collecting data from the used range of several sheets. The ...
