XL: Error Calling Macro Contained in Open Add-In

WORKAROUND

• Open the add-in file (either before you run the macro, or as a command in the macro), and then use the Run method of the Application object to run the macro as in the following example:

        Application.Run("ADDIN.XLA!Macro_Name")
  						

  -or-
  
  
• Reference the add-in from the procedure that is calling the add-in macro with the following steps. (Note that when you use this procedure, the path to the add-in file is hard-coded in the module, so that in order to run the procedure, the add-in file must be located in the same directory as when you referenced it.)
  
  
  1. Activate the module that contains the procedure that is running the add-in macro.
  2. On the Tools menu, click References.
  3. If the add-in that contains the macro you want to run is listed in the Available References list box, select (check) its checkbox. Click OK, and skip step 4.
     
     If the add-in that contains the macro you want to run is NOT listed under Available References, click Browse.
  4. From the File Name list, select the add-in you want to reference and click OK. Click OK again.