XLA for VSTO

I'm looking to create an excel add-in with .NET that will show up in the tools->add-ins dialog (i.e. an xla file) instead of the com add-ins dialog. Is this possible? If not, I will try creating an excel spreadsheet with VSTO and then creating an xla to open that spreadsheet.
[280 byte] By [JustinStarnes] at [2008-2-22]
# 1
Hey Justin:

VSTO 2005 supports document-centric customizations only.

Thanks!
Mike Hernandez
Community Program Manager
VSTO Team

MikeHernandez-MSFT at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...
# 2
Mike,

Any feeling as to why this is? Was it too hard? Is it coming later perhaps?

Thanks,

Aaron.

AaronRobertson-Hodder at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...
# 3
Hi Aaron,

This is somthing that we are looking into for future versions. As you can see with the VSTO 2005 for Outlook we are starting down this path. It is not a matter of being to hard , but a matter of resources and time.

Thanks for your feedback. Customer feedback like yours helps us prioritize the features for future versions.

Paul Stubbs
Program Manager - VSTO

PaulStubbs at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...
# 4
Paul,

I didn't mean to sound ungrateful, just been spending a lot of time trying to come to grips with the latest version!

We have a product that we have invested a lot of time in over the past couple of years, and I would like to see it move to VSTO and .Net. The main reason being the ability to make it appear as part of the Office suite by using the Actions Pane. Our problem is that the app is not document centric, but designed to be used across many documents, ie. global.

The fact that we can now use standard forms controls to develop the UI is fantastic (much better than the 2003 version!).

For now, I have come up with a work around, to enable to Action Pane for all document that are 'touched' by the app, which is to add the schema and solution to the document as soon as the user initiates use of the app (ie. from a button). I have been told that the ability to set the custom document properties that make this happen from VBA will be in the final version. I have also been told that this will require me to close and re-open the document! This is a problem, because the user hasn't even decided to save it by then, meaning I end up with a saved document that might just be thrown away.

So, I guess I have two requests:

- Let us have global solutions that utilize the Action Pane
- Let us set the schema and solutions details via properties and have them take effect immediately

OR

Just let us have complete control over the Actions Pane from a global assembly!

We promise to use it only for good! ;-)

Thanks.

Aaron.

AaronRobertson-Hodder at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...