4.0

4.0 | 5 ratings Rate this file 137 downloads (last 30 days) File Size: 2.36 KB File ID: #4562

msopen

by Fahad Al Mahmood

 

02 Mar 2004 (Updated 02 Jul 2009)

Code covered by BSD License  

Opens Microsoft Office files (Word, Excel, Power Point, Project, & Access).

Download Now | Watch this File

File Information
Description

msopen(file)
 
msopen : Opens Microsoft Office files (Word, Excel, Power Point, Project, & Access).
 
file: Name of file with extension (ex. 'Doc1.doc')
 
Examples:
 
msopen myfile.doc;
msopen myfile.xls;
msopen myfile.ppt myfile.xls myfile.doc;
msopen *.xls *.doc;

MATLAB release MATLAB 7.3 (R2006b)
Other requirements Microsoft Office (Word, Excel, Power Point, Project, Access)
Zip File Content  
Other Files license.txt,
msopen.m
Tags for This File  
Everyone's Tags
Tags I've Applied
Add New Tags Please login to tag files.
Comments and Ratings (7)
07 Mar 2004 Ibrahim ONARAN

Open an ms application is not that challenging. It is more important how to manage it by using matlab. Do you know some source that explain the functions and their parameters of this applications.

01 Oct 2004 Matthew Simoneau

See also winopen.m, built into MATLAB.

09 Aug 2005 Daniel Febres

i have a problem with this file. i used to open a xls file that must run the "MATLAB EXCEL LINK" macro, and this .m dont do that. it say me a error "the link is broken".

20 Sep 2007 Dany Simard

Thanks, good to do the simple task of opening those files

07 Aug 2008 Thierry Dalon

Indeed winopen seems to do the same.
msopen has following extended features:
- can open several files in a row
- allows wildcard in filespec
- allows partial path
which make it anyway very useful.

I would have following improvements (that's why only a 4 rating):
- it would be nice if you could take as input a list (cellstr) of files and not only the command window syntax.
- there is a small bug if no file was found. (you should check if output of wildfiles==0 to exit properly)

I am using this file because I want to be able to open also txt files with Excel. I've modified the file
switch fext
        case {'.xls','.xla','.xlt','.txt'}
so it handles this.
This can winopen definitely not do as well!

02 Sep 2008 David Hayden

dos('filename') is easier, except if you have spaces in your filename.

13 Oct 2009 Kimberly

Is this command similar to officedoc and winopen.m?

Please login to add a comment or rating.
Updates
08 Mar 2004

Multiple file option added

09 Mar 2004

Fixed file path bug

01 Apr 2004

Fixed another path bug

13 Apr 2004

Now can open Project & Access

05 May 2004

Changed Category

26 May 2004

Now supports wildcard

27 May 2004

Fixed a bug caused by (wildfiles) function

01 Oct 2004

Supporting Full or Partial Path

02 Jul 2009

Now Supporting Microsoft Office 2007 extensions

Tag Activity for this File
Tag Applied By Date/Time
path Fahad Al Mahmood 22 Oct 2008 07:15:23
directories Fahad Al Mahmood 22 Oct 2008 07:15:23
files Fahad Al Mahmood 22 Oct 2008 07:15:23
open Fahad Al Mahmood 22 Oct 2008 07:15:23
microsoft Fahad Al Mahmood 22 Oct 2008 07:15:23
word Fahad Al Mahmood 22 Oct 2008 07:15:23
excel Fahad Al Mahmood 22 Oct 2008 07:15:23
power Fahad Al Mahmood 22 Oct 2008 07:15:23
point Fahad Al Mahmood 22 Oct 2008 07:15:23
project Fahad Al Mahmood 22 Oct 2008 07:15:23
access Fahad Al Mahmood 22 Oct 2008 07:15:23
 

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.

Contact us at files@mathworks.com