Export to Excel error

Vineeth.R

Dear Friends

when i tried to write coding in a report to export to excel i encounter this automation error as attached with this. I am using Version 4.0, the error coming from
table 370
function Createsheet() this line.

XlWrkSht.Range(GetExcelReference(5) + ':' + xlColID + xlRowID).Columns.AutoFit;



In the Report when i call this function

ExcelBuf.CreateBook;
ExcelBuf.CreateSheet('Book 1','Book 2',COMPANYNAME,USERID); //Error comes here
ExcelBuf.GiveUserControl;
ExcelBuf.ChangePageSetup(2);
ERROR('');

Vineeth.R

The attachment

Sog

See that in the CU the text constant text016 is A1
check the values for xlColID and xlRowID and make sure it doesnt fall out of range (ColID has to be a sting containing one or 2 letters and must not pass IV.