Excel Link and matlab -- trouble updating data | Matlab DSP

Technical discussion about Matlab and issues related to Digital Signal Processing.

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

(You need to be a member of matlab -- send a blank email to matlab-subscribe@yahoogroups.com )

Sign in

Search matlab

Subscribe to matlab

matlab by Keywords

Discussion Groups

Discussion Groups | Matlab DSP | Excel Link and matlab -- trouble updating data

Excel Link and matlab -- trouble updating data - Dan Grabski - Jun 1 18:40:00 2001