Excel automation - sheet order

wilk_u
wilk_u Member Posts: 94
Thing is about using Workbook.Worksheets.Add function.

There are gl accounts with nos from 1 to 10, onAfterGetrecord creates new sheet with no in name 1,2,3 etc..
problem is that excel adds new on top and the order in book is 10,9,8,7.. is there any way to reverse it?
Greetings

Comments

  • Andwian
    Andwian Member Posts: 627
    Just a glance idea, not tried it yet. :idea:

    Just reorder the sorting, descending, before print it to Excel.
    Regards,
    Andwian