Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Cape Cod
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add-ins in Macros (Excel2000)

    Is it possible to run an AddIn in a Macro. In this case it's a MonteCarlo Simulation.
    In the middle of the macro I have to run the MCSim add-in. Seems that I will have to End Sub,Then run the Add In and start a new Macro to continue. Is that the way it works?

    Paul B

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add-ins in Macros (Excel2000)

    In the Visual Basic Editor, select Tools | References...
    You should see MCSimAddin, either in the list of checked references, or just below it. If it is not checked, do so now.
    You should now be able to call procedures and functions from the add-in in your own code.
    You can view what is available in the Object Browser (F2). Select MCSimAddin in the list of libraries.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •