Open an existing Excel file in the current instance

Question

I've written an Excel Addin for Office 2013 with C# language.

I know there is a few ways to open an existing Excel file, but all of them open the file in a new instance on Excel.

I have a current instance of Excel and want when somebody clicks on a button, the new file is opened in the current isctance(not a new one)!

for example I use the following piece of code:

Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;
string workbookPath = (@"C:\Downloads\Sample.xlsx");
Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(workbookPath,
    0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "",
    true, false, 0, true, false, false);

But this code opens the Sample.xlsx in a new instance of excel file.

Any Idea?

Thanks in advance.

LS_ᴅᴇᴠ · Accepted Answer · 2013-09-13 09:11:50Z

6

Instead of creating a new object, use Marshal.GetActiveObject:

Excel.Application excelApp = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application");

answered Sep 13, 2013 at 9:11

LS_ᴅᴇᴠ

11.2k1 gold badge27 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mori Over a year ago

I used your solution but nothing changed. That still opens the file in a new instance of Excel.

LS_ᴅᴇᴠ Over a year ago

This works fine to me. Can it be your Excel configuration, not allowing MDI?

Mori · Accepted Answer · 2013-09-13 12:52:45Z

3

Plus @LS_dev solution, I added excelApp.ActiveWorkbook.Close() command to make it work.

Excel.Application excelApp =  (Excel.Application) System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application");
        excelApp.ActiveWorkbook.Close();
        string workbookPath = (@"C:\Downloads\Sample.xlsx");
        Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(workbookPath,
                0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "",
                true, false, 0, true, false, false);

answered Sep 13, 2013 at 12:52

Mori

2,5846 gold badges28 silver badges49 bronze badges

Collectives™ on Stack Overflow

Open an existing Excel file in the current instance

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related