CODEWITHSUNDEEP
c#.netexcelinteropautomation
Joan Venge
Joan Venge

Reputation: 331112

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

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

Upvotes: 4

Views: 3306

Answers (2)

Joan Venge
Joan Venge

Reputation: 331112

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;

Upvotes: 3

SLaks
SLaks

Reputation: 887489

You're looking for the Workbooks property.

Upvotes: 1

Related Questions