5.0 | 1 rating Rate this file 23 downloads (last 30 days) File Size: 3.31 MB File ID: #11868

Handling MATLAB Events in Excel

02 Aug 2006 (Updated 02 Aug 2006)

No BSD License

Source code for Sept. 2006 News and Notes Programming Patterns article.

File Information
Description	The Global Temperature Explorer application demonstrates how to integrate MATLAB GUIs into Excel by writing Visual Basic callbacks that can respond to events generated by the GUI. The application consists of two parts, a COM component generated by MATLAB Builder for .NET, and a Visual Basic class module that integrates the COM component into Excel. The COM component consists of M-files and data files; it displays a data navigation GUI and exports two events: "DisplayLocation" and "PlotTempData". The Visual Basic code contains callbacks that respond to the exported events and a macro used to launch the data navigation GUI.
Required Products	MATLAB Builder NE MATLAB Compiler
MATLAB release	MATLAB 7.2 (R2006a)
Other requirements	Tested on Windows XP, Service Pack 2. Microsoft Visual Studio 2003 or later (to compile COM component). Microsoft Excel (to run the application).
Zip File Content
Other Files	TempAnomaly.cls, TempAnomData1880.mat, TempAnomTool.bas, Cities.csv, DisplayLocation.m, GlobalTemp.m, PlotTempData.m, README.txt

Tags for This File
Everyone's Tags	compiler builder net excel events programming patterns global wa, external interface
Tags I've Applied
Add New Tags	Please login to tag files.

Comments and Ratings (3)
16 Dec 2006	Hipson Israel	VB excel Programing work book
16 Dec 2006	Hipson Israel	please excel programing note sent By Hipson Israel
05 Oct 2009	Baiju Max	Hi, I have written a long running algorithm (takes 15 to 30 Mins to complete) in MatLab and converted it to a dotnet 2.0 assembly using 'deploytool'.I am using VC# to call the Matlab function and everything works just great. However the only problem is that i cant see the progress of the program .The user clicks OK button and then he has to wait for 15-30 minutes for the results. One solution I see to solve this problem to raise events (to report progress) from matlab and subscribe the same in VC# and inform the user about the progress. Is there any way of doing the same?

Please login to add a comment or rating.

Tag Activity for this File
Tag	Applied By	Date/Time
external interface	Peter Webb	22 Oct 2008 08:34:20
compiler builder net excel events programming patterns global wa	Peter Webb	22 Oct 2008 08:34:20

MATLAB Central Terms of Use

NOTICE: Any content you submit to MATLAB Central, including personal information, is not subject to the protections which may be afforded information collected under other sections of The MathWorks, Inc. Web site. You are entirely responsible for all content that you upload, post, e-mail, transmit or otherwise make available via MATLAB Central. The MathWorks does not control the content posted by visitors to MATLAB Central and, does not guarantee the accuracy, integrity, or quality of such content. Under no circumstances will The MathWorks be liable in any way for any content not authored by The MathWorks, or any loss or damage of any kind incurred as a result of the use of any content posted, e-mailed, transmitted or otherwise made available via MATLAB Central. Read the complete Terms prior to use.