You can open a file in Excel and open the same file using ODBC, but if you use the Excel Load function an exception is thrown saying the file is already in use. Is there any way to get the same behavoir that you would get if you used ODBC?
Thanks for the prompt reply. Works a treat. :-)
The answer to this question explains how using a FileShare value of ReadWrite might help here. Try to open your file with this solution and then pass the FileStream instance into Workbook.Load.