VBA Excel Automation Error - 1004
Public xlapp As Excel.Application Set xlapp = GetObject(, "Excel.Application") Dim CurrAddin As Office.COMAddIn For Each CurrAddin In xlApp.COMAddIns ... Next CurrAddin
Above is the sample code i am using to load all the relevant Addins to MSEXCEL through VBA automation. This is working fine on multiple 32 bit systems but when i tried the same code using a Windows 64 bit system, i got error as
Error in MyAddInEnumerator 1004 Method '~' of object '~' failed
I had maintained the same environment variables and paths on both the system for the COM Addins package and repository. Not sure what is causing the error. Is this some bug, or do i need to change my code to be compatible with both 32 bit and 64 bit systems. Also to let you know, my VBA code works fine across multiple Windows OS without any error.