Reply by Dan Grabski June 1, 20012001-06-01
I'm using Matlab R12 with Excel 2000 under Windows ME to do some
data analysis. I'm using Excel Link to pull data from cells in an
Excel spreadsheet, then using MLEvalString a lot of times to work
with the data. I have all of this written as a subroutine in the Excel
workbook, which is called by clicking a button I inserted in the
workbook. In the code, I start by running

MLEvalString "clear"

in the subroutine to clear out previous variables in Matlab. When I
first run the subroutine, it works fine. Then, the subsequent times
I run the subroutine after changing the data in the Excel sheet it
uses, it doesn't seem to have seen the new data -- all of the results
that come out use the old data. It doesn't update the data unless
I go into the Matlab window and run a command, any command, that uses
one of the variables I made through the Excel/Matlab subroutine code.
Is there something that tells it to explicitly update everything it's
looking for in Excel that I'm probably missing?

Dan

--
Dan Grabski | | This space intentionally left blank
PGP public key at http://cif.rochester.edu/~alain/pubkey.txt
"I don't make mistakes. I make prophecies which immediately turn
out to be wrong." -- Murray Walker on his Formula 1 commentary