Help on Custom Task Pane in Excel 2007 using Managed code...

[Venkataramana]

Hi,
Is it possible to build custom task pane using C#?
If yes, can someone point me to the correct links/resources for building
custom taks pane for Excel 2007 using managed code (C#)?

Best Regards,
Venkataramana

 

[Bob Phillips]

Mathias has an example at
http://www.clear-lines.com/blog/post/create-excel-2007-vsto-add-in-getting-started.aspx
which builds a task pane amongst other things.

 

[vrkorada[Hotmail]]

Hi Bob,
Thanks for the link. This seems a COM add-in and installed properly while
compiling the code, but how do I deploy the same on another machine? When I
tried to add the add-in, it is giving an error 'Not a valid COM add-in'

Can I keep the add-in files in a network share and still add to excel
client? I am looking for an easy distribution without requiring installation
through admin account.

Best Regards,
Venkataramana

 

[Bob Phillips]

Deployment has always been a nightmare with .Net, but is much better with VS
2008. What version are you using?

--

HTH

Bob

 

[vrkorada[Hotmail]]

I am using VS2008 prof.
Do I need to build a setup project for this?
I am working with a non-admin account and I am wondering, how the add-in got
installed just by compiling the project on my machine.

Best Regards,
Venkataramana

 

[Mathias]

Hi Venkataramana,

Yes you will need a setup project to deploy a VSTO add-in, and as Bo
said earlier, this isn't the most pleasant part of the process. Th
following walk-through from MSDN describes how to do it for a 2003+200
add-in, this should give you a good idea of where to start:

'Deploying Visual Studio 2005 Tools for the Office System SE Solution
Using Windows Installer: Walkthroughs (Part 2 of 2)
(http://msdn.microsoft.com/en-us/library/bb332052.aspx)

(I will add a post on creating a setup later but I just didn't have tim
yet)

As for why it installed on your development machine without admi
privileges, this is an interesting question. VSTO projects get installe
locally so that you can debug them, but I am not sure about the questio
of the privileges!

Cheers,

Mathias


;694833']I am using VS2008 prof.