Problem opening Excel workbook using Excel Interop

Question

I'm writing a C# forms application to open an existing Excel workbook using the Excel Interop. Everything works fine. I can read and write fine. I do not save the workbook until the user close the C# application. The problem happens when my program is running and the user accidentally opens the same workbook with Excel. I get the error:

Exception from HRESULT: 0x800401A8

at this line

Range excelRange = worksheet.UsedRange;

Is there a way to lock the workbook and not allow the user to open it with Excel when my program is running?

Thanks

Hans Olsson · Accepted Answer · 2010-05-06 09:11:26Z

1

There's probably some better way of doing this but the only way I can think of would be to:

Copy the Excel file to a temporary location
Lock the file in the original location so noone can access it.
Work with the temporary file.
Save and close the temporary file.
Unlock and delete the original file.
Copy the temporary file to the original location.

answered May 6, 2010 at 9:11

Hans Olsson

55.1k16 gold badges99 silver badges118 bronze badges

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

Collectives™ on Stack Overflow

Problem opening Excel workbook using Excel Interop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related