Export to Excel Error

Lamba
Lamba
edited 2013-09-10 in NAV/Navision Classic Client
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. ](*,)

Comments

  • vijay_g
    vijay_g
    Are you using any Automation var for access net in navision?
  • BernardJ
    BernardJ
    Preferably use 
    xlRange := xlSheet.Range('A1');
xlRange.Value := 'xyz';
    instead of 
    xlSheet.Range('A1').Value := 'xyz';
  • andrew118899
    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
    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
    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!
    Big D signing off!

Categories