Excel Add-in Development in C/C++

gallag · August 31st, 2004, 3:44 pm

I'm always having trouble linking to C++ dlls from Excel/VBA. I thought I'd buy a book to get the various problems solved once and for all.Has anyone heard anything about this book ? Worth ordering straight away ? Any good alternatives to it ?Regards

battant · August 31st, 2004, 9:10 pm

I haven't this book but for your problem, you can used a code like that :Sub auto_open() dllInstalled = False Dim strFromPath, strToPath As String strFromPath = Application.ActiveWorkbook.Path & " & blabla.Current path" strToPath = Application.Path & " & blabla "_ FileCopy strFromPath, strToPath dllInstalled = True Exit SubEnd SubGood luck

gallag · September 1st, 2004, 8:02 am

???????????

battant · September 1st, 2004, 9:45 am

What's your problem ?You don't understand what I mean.In fact, this macro has for goal to make a link between your macro and your dll.So, I think (normally) that it can help youIf you want further explanations, don't hesitate

gallag · September 1st, 2004, 11:59 am

Thank you Battant,No, I don't understand what you mean. The code you have attached has nothing to do with linking to dlls.In fact, I was more interested in finding out about the book...Regards

patch22 · September 1st, 2004, 2:57 pm

if you want the answers to your questions before december i would say look up the excel 97 sdk (book), a lot of which is provided at www.whooper.co.ukalternatively you just want any example of linking a C dll to VB, plenty on the net.

WilmottBookshop · September 1st, 2004, 3:02 pm

Excel Add-in Development in C/C++ currently has a due date of 31st October in the UK and December in the States.Suzanne

wdgann · September 2nd, 2004, 4:08 am

Download Quantlib from Sourceforge. With it is the source for QuantlibXL (an XLL addin) . Follow the example set forth in that and you should have no problem. You will also need to download XLW which is a wrapper for all the Excel to DLL calls. That book looks interesting though.

DominicConnor · September 2nd, 2004, 12:28 pm

I have the notes I wrote for my Excel DLLs lecture, if you like...

Duality · September 2nd, 2004, 5:31 pm

Hi DCFC,I would like to see your notes if you don't mind. Cheers...D

pcerutti · September 3rd, 2004, 5:30 am

Can I have a look at your notes as well?Thank you very much.have a nice weekend.Pierluigi

DominicConnor · September 3rd, 2004, 10:45 am

Here you.This is the version I did at the end of the CQF C++ course

Cuchulainn · September 3rd, 2004, 12:10 pm

In the book "Financial Instrument pricing in C++" (Wiley) Daniel Duffy has written a reasonably deep account of using VBA, C++, COM, C (XLL)with Excel (both input and output).This chapter discusses most things from the non-supported XLL (will not be upgraded) to the presentday.You asked about examples: see the accompanying CD where we have ready-to-run examples that you can customise.

Cuchulainn · September 3rd, 2004, 12:10 pm

In the book "Financial Instrument pricing in C++" (Wiley) Daniel Duffy has written a reasonably deep account of using VBA, C++, COM, C (XLL)with Excel (both input and output).This chapter discusses most things from the non-supported XLL (will not be upgraded) to the presentday.You asked about examples: see the accompanying CD where we have ready-to-run examples that you can customise.

DominicConnor · September 3rd, 2004, 3:20 pm

Why do you write about yourself in the 3rd person ?