Checking Instance of File

[Mohammad Abdullah]

Hi

If I want to toc check the instance of file (X.xls) is it open or not? How I can do this? provide example with (Iworkbook) object.

[Administrator]

Hi Mohammad,

Here is a code snippet to check for a file that already exists

try
{
myWorkbook.SaveAs("Sample.xls");
}
catch (System.Runtime.InteropServices.ExternalException ex)
{
if(ex.ErrorCode == -2147287007)
{
MessageBox.Show("The file that you are trying to create is already open","File is Open");
}
}

Thanks,

Stephen.

>Hi
>
> If I want to toc check the instance of file (X.xls) is it open or not? How I can do this? provide example with (Iworkbook) object.