How do I include XLL add-ins and register them?

It is possible to register add-ins in XLL format by listing them as companion files to your workbook.

To do this, you need to have 2 versions of your add-in: 32-bit and 64-bit formats. The filename’s extensions must be modified as shown on the screenshot below, so that XLS Padlock registers the correct version with Excel at runtime:

Then, to load the add-in in your workbook, you can use the following VBA code:

Public Function PathToCompiledFile(Filename As String)

Dim XLSPadlock As Object

On Error GoTo Err

Set XLSPadlock = Application.COMAddIns("GXLSForm.GXLSFormula").Object

PathToCompiledFile = XLSPadlock.PLEvalVar("XLSPath") & Filename

Exit Function

Err:

PathToCompiledFile = ""

End Function

Private Sub Workbook_Open()

Dim success As Boolean

' Load XLL

success = Application.RegisterXLL(PathToCompiledFile("sample.xll"))

End Sub