Automation Server Error


We develop one report in Navision 3.70A using Automation Server to direclty import into MS-Excel2003.

In between the report it is giving me following error

An exception was raised oon method value.The OLE control or Automation Server has returned the error(HRESULT) -2147352567.

The componenet did not provide the exception description.

How to resolve this error

Please help



It’s hard to tell how to solved it. That error is related to incorrect use of automation.

Turn on the Debugger and see where it stops. Paste the code in here. I believe when you assign a value to an excel sheet that shouldn’t be blank or something similar.