How to get the current open documents in Excel using C#?

Question

All I need is to get the list of currently open documents in the currently open instance of Microsoft Excel.

But I don't know Excel terminology to know if these documents are called workbooks, or sheets, or windows, etc.

Any ideas

Answer 1

You're looking for the Workbooks property.

Answer 2

Found it (link).

//Excel Application Object
Microsoft.Office.Interop.Excel.Application oExcelApp;

this.Activate ( );

//Get reference to Excel.Application from the ROT.
oExcelApp = ( Microsoft.Office.Interop.Excel.Application ) System.Runtime.InteropServices.Marshal.GetActiveObject ( "Excel.Application" );

//Display the name of the object.
MessageBox.Show ( oExcelApp.ActiveWorkbook.FullName );

//Release the reference.
oExcelApp = null;