Share excel workbook containing dll

[tiredofit]

This site shows how to create a dll in Visual Studio:

https://www.youtube.com/watch?v=SoO_uUPfHOI&t=472s

Here is the C# code:

using System.Runtime.InteropServices;
namespace SimpleCalc
{
    [ComVisible(true)]

    public class Calculation {
        private int numone = 0;
        private int numtwo = 0;

        public void SetNumOne(int number) {
            numone = number;
        }
        public void SetNumTwo(int number)
        {
            numtwo = number;
        }
        public int addnumbers() {
            return numone + numtwo;
        }
    }
}

This is the VBA code:

Option Explicit

Sub Test()

    Dim obj As New SimpleCalc.Calculation
    
    obj.setnumone (10)
    
    obj.setnumtwo (20)
    
    Debug.Print obj.addnumbers()
    
End Sub

In order for the VBA code to run, a reference to SimpleCalc must be added in the VB editor.

The C# code is saved on my PC and everything works as expected.

My question is if I send this to another person, what would they have to do to make the VBA work? I assume references "do not travel" with the workbook.

Would I need to send the C# code as well and if so, where should that be saved?

Thanks

 

[RoryA]

References do travel with the workbook, but the referenced files do not. You would have to send them the dll as well, and they would need to register it.

 

[tiredofit]

References do travel with the workbook, but the referenced files do not. You would have to send them the dll as well, and they would need to register it.

Thanks for the info.

The reason for creating the dll is (as far as I'm aware) that it creates an extra layer of security to the standard VBA protection of the code.

But if you need to send the dll file in order for the workbook to function, doesn't that defeat the whole idea of security?

 

[RoryA]

No, since a dll is a compiled executable, not source code.

 

[tiredofit]

No, since a dll is a compiled executable, not source code.

Thanks