SERVING THE QUANTITATIVE FINANCE COMMUNITY

 
User avatar
daveangel
Posts: 17031
Joined: October 20th, 2003, 4:05 pm

Excel DNA + Excel 2010 + VS Express 2010

September 27th, 2012, 12:20 pm

have you tried sticking it in the xlstart folder ?
knowledge comes, wisdom lingers
 
User avatar
MaxCohen
Topic Author
Posts: 511
Joined: June 13th, 2007, 2:44 pm

Excel DNA + Excel 2010 + VS Express 2010

September 27th, 2012, 12:52 pm

Personal.xls
 
User avatar
Govert
Posts: 103
Joined: January 28th, 2006, 10:02 am

Excel DNA + Excel 2010 + VS Express 2010

September 27th, 2012, 12:57 pm

Lots of ways to add it as an 'Excel Add-in'.Easiest is to press Alt+t, i to get the dialog, then browse to your .xll. Else go File->Options->Add-Ins, then look at the bottom and pick 'Excel Add-Ins' and press 'Manage'.This can also be done from VBA as Application.AddIns.Add("c:\myaddin.xll").Installed = True.Copying to xlstart should also work, but then you need to put the other dependencies in there too.-GovertExcel-DNA - Free and easy .NET for Excel
Last edited by Govert on September 26th, 2012, 10:00 pm, edited 1 time in total.
 
User avatar
Cuchulainn
Posts: 59677
Joined: July 16th, 2004, 7:38 am
Location: Amsterdam
Contact:

Excel DNA + Excel 2010 + VS Express 2010

September 27th, 2012, 4:05 pm

QuoteElse go File->Options->Add-Ins, then look at the bottom and pick 'Excel Add-Ins' and press 'Manage'.Excel 2010 can't find this (Manage??), Govert. Am I missing something?
Last edited by Cuchulainn on September 26th, 2012, 10:00 pm, edited 1 time in total.
 
User avatar
Govert
Posts: 103
Joined: January 28th, 2006, 10:02 am

Excel DNA + Excel 2010 + VS Express 2010

September 27th, 2012, 4:10 pm

Sorry - nearly got it right:File->Options->Add-Ins, then at the bottom next to "Manage: Excel Add-ins" you press the "Go..." button.Alt+t, i is easier way to get to the same place.-GovertExcel-DNA - Free and easy .NET for Excel
 
User avatar
Cuchulainn
Posts: 59677
Joined: July 16th, 2004, 7:38 am
Location: Amsterdam
Contact:

Excel DNA + Excel 2010 + VS Express 2010

September 27th, 2012, 4:21 pm

Thanks, got it.Instead of Automation, I use Browse and go to your .xll and bingo.Nice. And thanks to Dave and Max.
Last edited by Cuchulainn on September 26th, 2012, 10:00 pm, edited 1 time in total.
 
User avatar
daveangel
Posts: 17031
Joined: October 20th, 2003, 4:05 pm

Excel DNA + Excel 2010 + VS Express 2010

December 28th, 2014, 9:08 pm

bumping backis it possible to debug a Excel-Dna xll by stepping into it from Exel (as in VC++) ? I am using VS Express 2010.thanks
knowledge comes, wisdom lingers
 
User avatar
MaxCohen
Topic Author
Posts: 511
Joined: June 13th, 2007, 2:44 pm

Excel DNA + Excel 2010 + VS Express 2010

December 29th, 2014, 7:28 am

Not done this for a while but you can do something like:Visual Studio -> Tools -> Attach Process -> Choose Excel instance running ExcelDNA in 'Available Procesess'
 
User avatar
daveangel
Posts: 17031
Joined: October 20th, 2003, 4:05 pm

Excel DNA + Excel 2010 + VS Express 2010

December 29th, 2014, 8:58 am

QuoteOriginally posted by: MaxCohenNot done this for a while but you can do something like:Visual Studio -> Tools -> Attach Process -> Choose Excel instance running ExcelDNA in 'Available Procesess'I haven't been able to attach to a process using Express. Perhaps I need to upgrade...
knowledge comes, wisdom lingers
 
User avatar
MaxCohen
Topic Author
Posts: 511
Joined: June 13th, 2007, 2:44 pm

Excel DNA + Excel 2010 + VS Express 2010

December 29th, 2014, 9:39 am

 
User avatar
ashkar
Posts: 274
Joined: October 17th, 2011, 9:25 am

Excel DNA + Excel 2010 + VS Express 2010

December 29th, 2014, 2:21 pm

Attach to process doesnt work for me with Excel-DNA for some reason. I didnt bother looking why though...Instead I launch Excel from VS2010 and pass the XLL as argument.
 
User avatar
daveangel
Posts: 17031
Joined: October 20th, 2003, 4:05 pm

Excel DNA + Excel 2010 + VS Express 2010

December 29th, 2014, 3:30 pm

QuoteOriginally posted by: ashkarAttach to process doesnt work for me with Excel-DNA for some reason. I didnt bother looking why though...Instead I launch Excel from VS2010 and pass the XLL as argument.how do you do that ?
knowledge comes, wisdom lingers
 
User avatar
MaxCohen
Topic Author
Posts: 511
Joined: June 13th, 2007, 2:44 pm

Excel DNA + Excel 2010 + VS Express 2010

December 29th, 2014, 3:36 pm

Something likeSolution Explorer -> Pick the solution -> Properties -> Debug -> Command Line Argumentshttp://community.sharpdevelop.net/forums/t/13737.aspx
 
User avatar
Govert
Posts: 103
Joined: January 28th, 2006, 10:02 am

Excel DNA + Excel 2010 + VS Express 2010

December 29th, 2014, 4:22 pm

The Express editions are a bit weird.The easiest way to get started would be to install a current VS version (like the free Visual Studio 2013 Community Edition), create a new "Class Library" project and then install the "Excel-DNA" package from the NuGet package manager. That should give you a project with all the Excel stuff configured correctly, and you can just press F5 to debug.-GovertExcel-DNA - Free and easy .NET for Excel
 
User avatar
MikeJuniperhill
Posts: 57
Joined: February 7th, 2004, 11:57 am

Excel DNA + Excel 2010 + VS Express 2010

December 31st, 2014, 10:32 am

Hi,This might be a bit out of topic, but wanted to give my small contribution to the issue. Just in case someone needs any hands-on examples on interfacing C# and Excel/VBA with Excel-DNA , I have been publishing a lot of such examples in my blog. These posts have been published mainly in March 2014.Happy new year for all Wilmotters!-Mike Juniperhill
ABOUT WILMOTT

PW by JB

Wilmott.com has been "Serving the Quantitative Finance Community" since 2001. Continued...


Twitter LinkedIn Instagram

JOBS BOARD

JOBS BOARD

Looking for a quant job, risk, algo trading,...? Browse jobs here...


GZIP: On