As regular readers will know, I occasionally delve into compiling code in C++, or even Fortran, as dlls and link to them with a short piece of VBA to communicate between the spreadsheet and the compiled code. I have also sometimes had a look at compiling code as an xll file, but found it all too hard, and it hasn’t been obvious to me what the benefits are. What do others think? Am I missing something? What are the benefits of compiling an xll file, compared with a dll?
For future reference (should I decide to have another go at the xll route), two useful looking resources are:
Make that three: