Error when creating Excel Worksheet from Nav 2009 R2

Dear all,

I am getting following error when creating an Excel worksheet

“An Exception was raised in method range. The OLE Control or Automation Server has returned error (HRESULT) - 2147352567. The Component did not provide the exception description”.

I am using Excel 2007 and it always worked for me with previous versions of Nav!! Any help will be greatly appreciated

Thanks in advance

As you are using Automation. you may be incrementing rows and column for your purpose , while decrementing the columns u may be decrementing more than what you have incremented …

This error occurs when the column or rows are out of scope.

Just check the rows and column are not going out more than avaliable in excel.

Thanks everybody for the response. It is resolved now. What I was doing wrong was increamenting Rows incorrectly vis-a-vis columns!!!