Hi Swan,

Even being ticked, the VBA Add-Ins are not loaded in automation mode.
Only COM Add-Ins are loaded in this case.

You can find some details on using of VBScript for Add-Ins loading in this link:
Histogram macro / atpvbaen cannot be found

Here is explanation from MS: Add-ins do not load when using the CreateObject command in Excel

Regards,
Vladimir