How do I obtain a list of all currently open workbooks through an Excel ACTXSERVER object in MATLAB 7.8 (R2009a)?

I am connecting to an instance of Excel using the ACTXSERVER or ACTXGETRUNNINGSERVER functions, opening a number of files, and reading data from them. Using the Excel COM API methods, I would like to be able to get a list of all Excel files that are currently open in the program.

Answer 1

[MathWorks Support Team]

Assuming you have created an ACTXSERVER or ACTXGETRUNNINGSERVER object named 'e' in MATLAB that connects to a COM/ActiveX instance of Excel:

% Opens a new server instance of Excel

   e = actxserver('excel.application')

% Obtains handle to existing running instance of Excel

e = actxGetRunningServer('excel.application');

the following code demonstrates how to obtain a list of all open Excel files (i.e., workbooks) by invoking Excel's COM API methods:

% Obtain handle to collection of open Workbooks in Excel

w = e.Workbooks;

% Get number of open Workbooks

numWorkbooks = w.Count;

% Query name of each open Workbook

for i = 1:numWorkbooks

      openFiles{i} = w.Item(i).Name;

end

% Display names of open Workbooks

openFiles{:}