Run XLAM from macro

[jtdewhurst]

Hello, I'm trying to run an XLAM file from a macro. Using the run method I get the following error

Run-time error '1004':

Cannot run the macro
(filepath)
The macro may not be available in this macro or all macros may be disabled.

I'm quite familiar with VBA, but am just starting with .xlam files, so I think that this is something really basic. I have macros enabled in the workbook.

Here is my run code.

Sub call_xlam_test()
    out = Run("C:\Users\joel.dewhurst\AppData\Roaming\Microsoft\AddIns\SingleCellToleranceParsingAddIn.xlam!ParseSingleCellTolerance", Sheets(1).Range("A1"), Sheets(1).Range("B1"))
End Sub

 

[AnAnalyst]

Hi,

I think the xlam file would need to have a digital signature applied to the VBA project. The digital signature would need to be trusted by the environment within which the code will run. Easy if you are running this on a single machine as you can self-certify a digital signature, but more complex if you are doing this in a corporate environment.