Mathematica Link for Excel fixed
- To: mathgroup at smc.vnet.net
- Subject: [mg59836] Mathematica Link for Excel fixed
- From: Murray Eisenberg <murray at math.umass.edu>
- Date: Tue, 23 Aug 2005 04:51:37 -0400 (EDT)
- Organization: Mathematics & Statistics, Univ. of Mass./Amherst
- Reply-to: murray at math.umass.edu
- Sender: owner-wri-mathgroup at wolfram.com
In a previous message to this group (sorry, I no longer have the
reference number), I asked how to get Mathematica Link for Excel to work
again now that I've updated Mathematica to version 5.2. Specifically,
after setting my default Mathematica kernel to MultiLink, initiating a
link to a Multilink kernel from Excel, and in a Mathematica notebook
assiging a value to a symbol (e.g., var = 5;), when I went back to Excel
and tried to retrieve that value [e.g., =Math("var")], nothing would happen.
A technician at Wolfram Research quickly found the cure: The Advanced
Options : Arguments to MLOpen for the MultiLink kernel (set in
Mathematica's Kernel > Kernel Configuration Options > Kernel Properties
menu item) were wrong. They should be:
-LinkMode Launch -LinkName "MultiLink -mathlink"
For unknown reasons, they were ERRONEOUSLY set as:
-LinkMode Launch -LinkName "MathKernel -mathlink"
Everything now works now as expected.
--
Murray Eisenberg murray at math.umass.edu
Mathematics & Statistics Dept.
Lederle Graduate Research Tower phone 413 549-1020 (H)
University of Massachusetts 413 545-2859 (W)
710 North Pleasant Street fax 413 545-1801
Amherst, MA 01003-9305