In what order do they appear or are they random?
I would guess that whatever happens is a function of the JetExportTable routine and may well be based on worksheet (i.e. filter in this case?) naming convention rather than in the order of processing. Or be totally random based on some other criteria.
Which is why I am interested to know what order you get.
I'm a Monarch V7 user.I've a model consisting number of filters.I m using the following code to export each filter in to a new work sheet of an excel file.Its working fine but I m missing the order, they are not exported as the same order I've defined in the model...
If nof <> 0 Then
For i = 1 To nof
cf = MonarchObj.GetFilterNameAt(i)
MonarchObj.currentFilter = cf
MonarchObj.jetExportTable App.Path & "output-files1102.xls", cf, 2
Thanks in advance.... /b[/quote]