problem in creation of work sheet

what did you try so far?

Can you us the code?

hi, are you creating the excel book by table excel buffer (370) or by automation??


if you are creating the excel book by table 370, try this.



in the table 370 create a new function named AddSheet whit that :


AddSheet()

XlWrkBk := XlApp.ActiveWorkbook;
XlWrkSht := XlWrkBk.Worksheets.Add;



now when you call the table 370 in a report try this;

XlBuffer.Createbook; // this only call once time because this create the excel book
XlBuffer.CreateSheet('title 1,'title2',COMPANYNAME,USERID);
XlBuffer.AddSheet;
XlBuffer.GiveUserControl;


XlBuffer is a type record from Excel Buffer