Mathematica 9 is now available
Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2002
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2002

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: mathematicalink for excel xp

  • To: mathgroup at smc.vnet.net
  • Subject: [mg35480] Re: [mg35465] mathematicalink for excel xp
  • From: "Jonathan Rockmann" <MTheory at msn.com>
  • Date: Tue, 16 Jul 2002 04:49:36 -0400 (EDT)
  • Sender: owner-wri-mathgroup at wolfram.com


Erich,

I experienced the exact same thing using Windows 2000 with Office XP and 
Mathematica 4.0.  Let me guess, you call the kernel somehow within Excel 
and you are first prompted to enable the macros, right?  Well that much is
normal.  So you select enable macros and if I recall correctly the next
thing that happens is you get another prompt saying "Using this command.
..yada, yada ...Do you want to connect to the kernel now?".  You select yes
again and that is when I believe you get the error message that you reported.
Well stop reinstalling the patch, it works fine.  I tried everything that
technical support could offer to no avail, was stuck having to 
figure it out myself and eventually was so tired of the whole "linking Excel
to Mathematica" thing that I that I opted for the solution of last resort:
I reinstalled Excel 2002 (or XP) without any non-Excel add-Ins, and
then reinstalled the patch again and it worked fine!  

Why does it work now?  It is probably because there was a conflict with one
of the Excel add-In programs I had been using (written by a third person),
however I had tried getting rid of all of these non-Excel add-Ins prior to
reinstalling Excel and that didn't take care of the problem.  I never used
these other add-Ins again so I can't tell you if they would corrupt the link
again if I had used them after I had achieved a successful link to Mathematica.
But there is also however the possibility that it had nothing to do with
these add-Ins and that there are just lots of problems with the link itself
but I don't have the time to pursue the details of every problem that I
experience while trying to use Mathematica and Excel together. 

I also encourage you to thoroughly read the manual.  But in the end, I have
found that the link is not a clean connection and if you prefer Mathematica's
computational engine and language to Excel's, you might end up like me
wishing there was some other way to get a spreadsheet into Mathematica.
Well there is a third-party vendor who is working on that problem right now
- his name is Jason Tiggs, the product is called Smartspread and
 the web address is www.smartspread.com.   

Salutations,

Jonathan Rockmann
mtheory at msn.com


----- Original Message -----
From: erich.neuwirth at univie.ac.at
To: mathgroup at smc.vnet.net
Subject: [mg35480] [mg35465] mathematicalink for excel xp

i am trying to use mathematica link for excel xp  on win2k
with mathematica 4.1.2

there is an update on wolfram's web site for this software combination,
but i always get an error:

runtime error 1004
unable to set visible property of drawingobjects class.

has anybody experienced the same problem?
is there a solution?


  • Prev by Date: Re: Re: Factoring question
  • Next by Date: Re: Changing delayed formula
  • Previous by thread: Re: mathematicalink for excel xp
  • Next by thread: How to Fix Time Steps for NDSolve