Export to Excel Error

Lamba

When i use the four basic functions to add the export to excel functionality to a customized report that i took from
the report -113(Customer/Item Sales).
And when i run the report the error occurs as:

This message is for C/AL programmers:

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. ](*,)

vijay_g

Are you using any Automation var for access net in navision?

BernardJ

Preferably use

xlRange := xlSheet.Range('A1');
xlRange.Value := 'xyz';

instead of

xlSheet.Range('A1').Value := 'xyz';

andrew118899

I experienced a similar problem which was caused by the value not being acceptable for Excel.

A customer name had T/A (Trading as) and the "/" character was not acceptable as a name for a worksheet.

kabroco

I got this error message when I used the wrong template, I wanted to use labels in the template in stead of columnnumbers.
The labelname fot the column could not be found in the template.

Big_D

I also got this error too when Exporting a Budget to Excel...

On the Options tab of Report 82 where they chose Column Dimensions - one of the shortcut dimensions had no dimension values - so this also caused the same issue - thought I would share this will you!