ExcelDNA on Shared Drive

Oct 20, 2013 at 11:10 PM
Hi,

I have been using Excel DNA on a local pc and it works very well.

However, I am trying to move the Excel DNA to a distributed environment as several users need to use it and I don't want to run around to upgrade PCs. Do you know how can I put the excel addin onto a shared drive onto the network rather than C drive? I tried it before but it looks like some libraries are missing.

Thanks
Coordinator
Oct 20, 2013 at 11:32 PM
Hi Kenneth,

It should work fine.
What .NET version are you targeting? .NET 4 can make the network scenario a bit easier.

But just have the file on a network drive does not sort all your problems out. While the add-in is loaded, the .xll file is locked, so can't easily be upgraded in place. One approach is to have different directories for different versions:
....\AddInMain\MyAddIn.xll
....\AddInMain\MyAddIn.dna
....\AddInMain\Version1\MyLibrary.dll
....\AddInMain\Version2\MyLibrary.dll

Now in MyAddIn.dna you put
<DnaLibrary RuntimeVersion="v4.0" >
<ExternalLibrary Path="Version1\MyLibrary.dll" />
</DnaLibrary>
Now when upgrading the version you just add a new directory, and change the .dna file (which won't be locked). Users loading the add-in again will get the new library, while working users won't be interrupted.

That's one idea...

Anyway, please post back if the network deployment still gives you an error.

Regards,
Govert