Hi Trevor,
You can the calling sheet info like this:
var sheetName = XlCall.Excel(XlCall.xlSheetNm, caller);
But it is a good suggestion to add some easier way to get e.g. the matching Range COM object.
-Govert
--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/b5106492-3d3d-4ee7-9ac7-43e693067083n%40googlegroups.com.
Hi Trevor,
Adding the extra add-in libraries seems to work fine for me.
I’ve made a small test project here: govert/TestMultiProj (github.com)
Here we have the ‘main’ add-in project (TestMultiProj) and then an addition add-in project (MoreFunctions) that should be a packed ExternalLibrary.
The key is to have the ProjectReference, and then also add an entry to the TestMultiProj.csproj file like this:
<PropertyGroup>
<!-- Comma-separated list of additional add-in libraries to add as 'ExternalLibrary' entries in the generated .dna file -->
<ExcelAddInExports>MoreFunctions.dll</ExcelAddInExports>
</PropertyGroup>
Let me know if this still does not work for you.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/b7377a69-c8fd-44ce-9bae-563003f7b75dn%40googlegroups.com.