Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel Link (MATLAB) help

Hello all who kindly choose to read this...

I'm trying to use Excel Link to pull out functions from MATLAB for use in
Excel. I'm currently using the matlabsub function provided by Excel Link. I
am working directly in the worksheet, and not using VBA code. (My boss, the
person who uses this spreadsheet, doesn't like to use VBA. He prefers to
work directly in the worksheet cells.) Anyway, I'm running into a snag with
this. If I try to pull a function that yields more than one result, e.g.
cfamounts(coupon, start date, end date) = [CFlowAmounts, CFlowDates], only
the first vector (CFlowAmounts) is showing up in Excel's cells. I won't see
the CFlowDates results at all. Does anybody know how to get multiple vectors
to populate Excel's cells?? The way I currently have this spreadsheet set up
is as follows...

=matlabsub(B10,C10, D10,E10,F10)
B10 = cfamounts (function name)
C10 = P10 (the cell I want the output to begin)
D10 = 8.25 (coupon amount)
E10 = 31-Jan-2002 (start date)
F10 = 31-Jan-2009 (end date)

I've tried fiddling with input signifying the output start cell with no
luck. The reason I have it set up like this is because I want to be able to
pull many different MATLAB functions, mostly user built. I want to be able
to specify them as I go. If anybody could help shed some light on this I
would be very grateful. Please let me know if I have been unclear about
anything, and I will try to correct this. Thanks in advance!

Cheers,
The Improper Californian
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use Excel like Matlab? sjlesnia Excel Discussion (Misc queries) 0 March 21st 07 10:14 PM
Matlab & Excel interface? cfman Excel Discussion (Misc queries) 1 March 21st 07 06:03 PM
Matlab & Excel interface? cfman Excel Programming 1 March 21st 07 06:03 PM
how can ý call matlab function from matlab to excel gurhan Excel Discussion (Misc queries) 0 November 29th 06 08:40 AM
VBA with Matlab using Excel Link but not Excel Builder James Excel Programming 9 June 3rd 05 10:48 AM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"