ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error after chaging file access in Office 2007 (https://www.excelbanter.com/excel-programming/409705-error-after-chaging-file-access-office-2007-a.html)

armaSANEA

Error after chaging file access in Office 2007
 
Hi,
I use Office 2007 PIA's.
I receive an exception in a very simple scenario: I open a 2007 xlsx file,
set it to read only, and then set it back to XlFileAccess.xlReadWrite. After
this I get an exception when trying to do anything with the workbook object.
Strangely, I do not receive this exception when working with Office 2003
files (compatibility mode).

Here is the code:
try
{
app = new Application();
Workbook wb = app.Workbooks.Open(@"D:\Documents\Docs\Office 2007
Samples\2007.xlsx",
0, false, Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
true, Type.Missing, Type.Missing, false, Type.Missing, Type.Missing);

wb.ChangeFileAccess(XlFileAccess.xlReadOnly, Missing.Value, false);
wb.ChangeFileAccess(XlFileAccess.xlReadWrite, Missing.Value, false);

//Exception when accesing anything on Workbook
Console.WriteLine(wb.FullName);
}
catch (Exception exc)
{
Console.WriteLine(exc.ToString());
}

Here is the detailed exception:
System.Runtime.InteropServices.COMException (0x80010108): The object invoked
has disconnected from its clients. (Exception from HRESULT: 0x80010108
(RPC_E_DISCONNECTED))
at Microsoft.Office.Interop.Excel.WorkbookClass.get_F ullName()
at TestConsoleApplication.Program.Main(String[] args)




All times are GMT +1. The time now is 11:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com