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
There's probably some better way of doing this but the only way I can think of would be to:
User contributions licensed under CC BY-SA 3.0