https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/44237.aspxMon, 13 Jul 2009 20:32:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:44237b.harrison0https://www.infopathdev.com:443/forums/thread/44237.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=44237<p>This may be more of an Excel question than InfoPath, but this forum has always been very useful and&nbsp;perhaps someone can help.</p> <p>From an InfoPath form I use an OpenFileDialog to open an Excel workbook and then retrieve some data to put in xml.&nbsp; Afterwards I close the Excel file.&nbsp; The problem is that until InfoPath is completely closed, if I try to open that workbook by itself, I get a message that it is locked for editing.</p> <p>Below is my open/close code.&nbsp; Is it something I am missing or doing wrong here?&nbsp; Thanks for any help</p> <p>// Open MS Excel and the selected workbook<br />Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();<br />Microsoft.Office.Interop.Excel.Workbook workBook = app.Workbooks.Open(<br />&nbsp;&nbsp;&nbsp; diag.FileName,&nbsp; // FileName<br />&nbsp;&nbsp;&nbsp; 0,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // UpdateLinks<br />&nbsp;&nbsp;&nbsp; true,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // ReadOnly<br />&nbsp;&nbsp;&nbsp; missing,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Format<br />&nbsp;&nbsp;&nbsp; missing,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Password<br />&nbsp;&nbsp;&nbsp; missing,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // WriteResPassword<br />&nbsp;&nbsp;&nbsp; true,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // IgnoreReadOnlyRecommended <br />&nbsp;&nbsp;&nbsp; missing,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Origin<br />&nbsp;&nbsp;&nbsp; missing,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Delimiter<br />&nbsp;&nbsp;&nbsp; missing,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Editable<br />&nbsp;&nbsp;&nbsp; missing,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Notify<br />&nbsp;&nbsp;&nbsp; missing,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Converter<br />&nbsp;&nbsp;&nbsp; false,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // AddToMru<br />&nbsp;&nbsp;&nbsp; missing,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Local<br />&nbsp;&nbsp;&nbsp; missing);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // CorruptLoad<br /></p> <p>//retrieve data...</p> <p>if (workBook != null) workBook.Close(missing, missing, missing);<br />if (app != null) app.Quit();<br /></p>