A DLL works for calling functions in other C++ programs, right?
From the bit of reading I did goolging around, though, I got the strong impression that COM or something would be needed to interface between C++ DLL's and other platforms, such as the VBA hosted by Excel.
This said, I'm really quite clueless since I've never done this sort of thing before. It's just that I keep hearing that it's not that simple.