Excel automations with VSTO, .Net

[lohithsriram]

Hello All,

Is anyone doing any automations on Excel with VSTO or .Net. I have got few questions for you. Thanks.

 

[bobhc]

Good day lohithsriram

I think you will get a better response if you actually posted your questions on a .NET of VSTO site

 

[SirJB7]

Hi, lohithsriram!
Not with VSTO but with .NET.
Regards!

 

[lohithsriram]

Thanks bobhc. I will put my questions on those forums as well.

SirJB7,
I am currently working with some automations on Excel through VB.net. When it comes to deployment, VBA always had a upper hand to wrap everything in the EXCEL file and distribute the file to anywhere, anytime. Since the output of .Net is a dll and this needs to be distributed to clients along with your EXCEL file, what best methods do you use in such scenarios? Do you use any external/third party tools to wrap it both into one single file.

I found this EXCEL DNA link which talks about wrapping your .Net code as an XLL and use in Excel as a com addin. Did you use this in past and what's your general opinion about using this idealogy? Thanks.

http://exceldna.codeplex.com/