|
I have a .NET (C#) addin that uses a COM Shim dll to load itself into Excel. The addin works fine without any problem when Excel is run normally. The addin displays its own custom toolbar in Excel that is used to execute different commands.
When I embed...
Started by A9S6 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
According.
To either stop embedding Excel into the application OR use only Excel 2007 that has a Ribbon UI.
|
|
We have a VSTO application-addin (not a document-addin) for Excel, and we want to expose an event to VBA code so that the VBA macro can do some action when this event fires in the addin. How can I get the VBA code to be able to subscribe to an event defined...
Started by Kang Su on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Add-in is technically a DLL that is being loaded into Excel, it operates more like a top-level EXE.
|
|
Hi,
I have an addin which I want to invoke through Excel interop from a C# winforms application.
I can't get the addin etc. to load unless I uninstall and resinstall it each time (this is apparantly something to do with Excel not loading addins when you...
Answer Snippets (Read the full thread at stackoverflow):
Here's some rudementry code to get started:
var excel = new Application(); var workbook = excel.workbooks.Add.
Things to note: you must have at least one workbook open or otherwise Excel barfs.
|
Ask your Facebook Friends
|
I am a newbie with addin programming and need help with the following scenario.
I have an C# excel automation addin that calls a few UDFs. I want to do a user name and password check during when the automation addin loads for which a screen where the ...
Answer Snippets (Read the full thread at stackoverflow):
But an automation add-in is not generally designed to handle Excel object model events and password check....
addin to handle my excel events, how do I incorporate my UDF functions ? Will they be exposed of the 'Excel.Application' class.
|
|
If I want to build an excel addin with C++. Is there any opensource/freeware alternative to the Visual Studio development environment?
Thanks
Dean
Started by mileyd on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
With excel 12 they added some the Excel SDK and make sure....
I'm not sure on it's current state of development or if it is updated for the current version of excel.
For interfacing with excel you can use should check out XLW .
|
|
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 Application...
Started by Jon Fournier on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The addins listed in the Tools->Addins menu, with a boolean value stating whether or not an addin.
|
|
I am writing an Excel 2007 Addin. using VS2008 and .net 3.5, C#.
I catched Microsoft.Office.Interop.Excel.Application's WindowActivate and WindowDeActivate events.
It was surprised to know that WindowActivate and Deactivate only triggers when i switch...
Answer Snippets (Read the full thread at stackoverflow):
But not when switching between....
When switching between two excel windows, the event is fired.
I solved this issueI have the same issue with Excel 2003.
No dll import is needed.
I solved similar problem when writing Excel addin.
|
|
I developped a VSTO SE Excel 2003 add in. When launching and debuging the add in from visual studio, it works well. But when I try to deploy it from my own install it never works.
To sum up, here is my install process:
the files are copied at the right...
Started by JF on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Called VSTO_SUPPRESSDISPLAYALERTS with the value 0, reinstall/repair your addin, then try running Excel again..
|
|
Hi there,
I've developed an Excel 2003 addin in C#, using VSTO and VS 2008. The addin works just fine on my machine (HP NC6320 laptop, 3gb RAM T5600 1.8ghz Core2 cpu), however when it is tested on another users machine (HP nc6710b laptop 2gb RAM, T720...
Started by nHaslam on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
Check the version of installed VSTO....
Google Office Addin) or any other potentially event-trapping code in Personal.XLS etc
Presumably starting dumping your data to spreadsheet to stop any other Excel Add-Ins or any VBA code waiting Update).
|
|
Hi,
How do I know which methods are available in my XLL module, in case i need to use / call any of them in my VBA code.
I can do this by calling the:
Application.Run()
method, in which I have to pass my macro-name as the parameter.
My question is about...
Started by tush1r on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For example.
To give you a list of the functions in the XLLs that Excel has registered.
|
