If you want to transport function from c++ into excel what is the difference in DLL and xll add in. IE when should one use one and not the other..And by transport I mean write the function in C++.net but be able to use it in excel and C++.net framework

An XLL add-in is a DLL as well, but uses the C interface. A COM DLL is using the COM interface. Which one you should use depends on the task and the Excel version. There is still a difference between a native DLL and a managed DLL (also called assembly). For an XLL interface to managed code see ManagedXLL. J.

An xll is a dll with added specialized functionality which allows it to be used directly in the spreadsheet via the Excel C API. Functions in an xll will appear in the Excel Function Wizard and behave like any native Excel worksheet function. Xll functions are NOT easily accessible in VBA modules or elsewhere, however.

Xll functions are NOT easily accessible in VBA modules or elsewhere, however.I consider Application.Run("YourXllFunctionHere", a, b, c) easy

Ok here comes the next question...How do I create the xll in visual C++.net framework?I'm going to file new project and then lost

See private message.

jens,Application.Run works but it is pretty inelegant, more like last resort brute force. Don't all arguments have to be variants (I used it so long ago I can't recall offhand)?

Application.Run works but it is pretty inelegantthat holds for VBA in general...

As long as we're being brutish and inelegant, you can create an XLA that consists uniquely of Declare statements.

Old thread but a useful one I guess. Application.Run works with both variants and explicit types. Ugly as sin & looks like a real afterthought by the MS devs!

how do u incorporate a customised function in C++.. into MS excel through dll/xll??? i have tried everthng... doesnot work though... please help me out....tried using sample codes on net... still does not work...

Hi gatechfe08,There is a nice article in codeproject.com.I have made a dll in C++ Borland with the help of the person who has written the article on codeproject.The function is to sum two integers and return the sum in a cell in excel.You need the Borland 5.5.1 compiler for this.The Code(sumtwoints.cpp)----------------------------------#define dllexport __declspec(dllexport)extern "C" {dllexport _stdcall int sum_two_integers (int first, int second) { return first + second; }}The Command line compile---------------------------------BCC32 -tWD -O2 sumtwoints.cppThe output will be a sumtwoints.dll. This should be copied into the same folder where your excel file sits.Now open VBE of Excel. Add this line in a VBA module.Public Declare Function sum_two_integers Lib "sumtwoints" (ByVal first As Long, ByVal second As Long) As LongGo to cell in workbook. and type sum_two_integers(1,2). You should be getting the results. Remember to use the latest compiler. google it.Regards

Hi Elektor,I have several quastions to your post, if you do not mind:1. I suppose you have to use DLL WIZARD in bcb to write "Code(sumtwoints.cpp)", right?2. Shouldn't there be any dllimport in the subsequenst statement?3. Could you explain what this "-O2" in "BCC32 -tWD -O2 sumtwoints.cpp" means?Regards,PiotrW