Inserting an ExcelSheet

Hi there,

I want to export a Report (e.g. Report 4 Detail Trial Balance)directly to Excel.

A new Excel Sheet is inserted BEFORE existing Sheets - it should however be inserted AFTERwards to keep the output in the same order as it is displayed on the report itself.

My Questions:

1. How can I manage this[?]
2. Can I use any MOVE-instruction like this:
XlWorkSheet.Move([VARIANT Before][, VARIANT After])
I haven't found out yet how it works...


Thanks in advance for your help.

Juergen
Parents
No Data
Reply
  • hi,
    use this, it works

    create(xl);
    xl.visible:=true;
    xlworkbook:=xl.workbooks.add;

    xlsheet := xl.ActiveWorkbook.Sheets.Item(xl.ActiveWorkbook.Sheets.Count);
    xlsheet.Activate;
    xlsheet.name:='Detail Trail Balance';

Children
No Data
Related
Recommended