connectrion my C# code to external Excel file

Asked Dec 03 '16 at 15:19

Active Dec 03 '16 at 15:19

Viewed 143 times

I use to Open Excel files from my C# Interop application. However, I cannot pick up (or get connected to) Excel file, when it is already "in air" - open manualy.

app = new Excel.Application();
foreach(var w in app.Workbooks)
{
    if(w.name == "MyFile") found = true;    //never ever found 
}

Could you please advice How To get connected to MyFile.xlsx, not just Open it?

asked Dec 03 '16 at 15:19

Pavel Khrapkin

Are you asking how to open a workbook? - `var workbook = app.Workbooks.Open(@"c:\path\myfile.xlsx");` – Alex K. Dec 03 '16 at 15:40
No Alex! app.Workbooks.Open I use many years. My question about openning (get connecting?) to the Excel file already open manualy by User. – Pavel Khrapkin Dec 03 '16 at 15:48
1

`Marshal.GetActiveObject()` E.g. http://stackoverflow.com/questions/6686886/how-to-access-an-already-opened-excel-file-in-c – Alex K. Dec 03 '16 at 15:51
1

Thanks Alex for point me this thread, it is definitely what I need! – Pavel Khrapkin Dec 03 '16 at 16:06

connectrion my C# code to external Excel file

0 Answers0