EXCEL-Mathematica Link for EXCEL & @Risk
- To: mathgroup at smc.vnet.net
- Subject: [mg73478] EXCEL-Mathematica Link for EXCEL & @Risk
- From: actuary at mchsi.com
- Date: Mon, 19 Feb 2007 01:28:09 -0500 (EST)
To: All I'm trying to develop an application in EXCEL that includes some Mathematica code. The EXCEL based application involves a Monte Carlo simulation. For controlling the simulation I use the EXCEL add-in @Risk. @Risk allows the user to run EXCEL macros at defined points in time in the simulation i.e. before the simulation starts, before each iteration, after each iteration, etc. To do this, one needs the fully qualified name of the macro. I'm writing Mathematica macros as described on pages 40-41 of the manual for Mathematica Link for EXCEL - Version 3.0. My question is "How do I identify the fully qualified names of the Mathematica macros for purposes of identifying them for the Monte Carlo simulation controlled by @Risk?" Thanks. Larry