Problem in Print To Excel

chandrurec
chandrurec Member Posts: 560
edited 2009-10-15 in NAV/Navision Classic Client
Hi all,

When i try to export a report to excel using the excel buffer table, i am getting a error as mentioned below.

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

Whta may be the reason ? if anybody knows the reason for this error, please reply. This is an urgent issue.

Thanks in advence.

Regards,
chandru.

Comments

  • vijay_g
    vijay_g Member Posts: 884
    hi..

    check variable ROWNO initialize or not it's cause of error.
  • Karenh
    Karenh Member Posts: 209
    In my experience, that error is caused by the result set exceeding the maximum number of Excel rows (64 thousand something).

    To test that, set a filter on the report to obtain a smaller result set. If you don't get the error, then that is likely the problem.
  • Cody89
    Cody89 Member Posts: 1
    Maybe you forgot to validate the fields "Row No." and "Column No." of the Excel Buffer-Table on inserting new values!???

Categories