Excel Interop Error

[kav123]

I get the following error when i try to access a range in an Excel worksheet:
Exception from HRESULT: 0x800A03EC.

The code at which it throws the error is:

oRange = oSheet.get_Range("NamedRange", Missing.Value).get_Offset(0, 1);

I have searched the internet could not find the solution. Please help!!

 

[PRPhx]

Have you looked here:

http://www.xtremedotnettalk.com/showthread.php?t=101649

???? Sounds like a permission problem?

Also add this code to to try catch block (if your code is wrapped around a try catch. It may give you more info.)

Catch the exception
try
{
... your failing COM code ....
}catch(Exception e)
{
MessageBox.Show("Exception " + e.Message + " Stack Trace: " + e.printStackTrace());
}

Here's more info. Almost sounds like you have an invalid range name.

http://bytes.com/topic/c-sharp/answers/494922-get_range-function-throws-exception