Clever Geek Handbook

Calling XLL from (unmanaged) C ++

I have an XLL Excel add-on and now another team wants to use the same functionality in their project (unmanaged C ++). Is there a way to interact with this XLL directly from C ++?

0


source to share


2 answers


Are you not managed or unmanaged XLL code?

As far as I know, the unmanaged C ++ XLL file is actually a DLL that exports certain methods called by Excel.



If your XLL has a .def file, perhaps you can add a method to be called by another command.

+1


source


You can use GET.WORKSPACE (44) to get a list of add-ons and their signatures. If you don't have hablo macro sheets, download xllutility.xll from http://sdrv.ms/JtaMIV and call = GET_WORKSPACE (44) on the cell. (Note the underline.)

The second column is the name of the function and the third is the argument list encoded as described here: http://msdn.microsoft.com/en-us/library/office/bb687900.aspx



Use the handy adjust.xll button from the link above to adjust the output to your desired size.

+1


source






More articles:


All Articles