1 Reply Latest reply: May 15, 2014 9:53 AM by Grant Perkins RSS

    How to Set the Order   -  Filters

    yesb _

      Hi,

      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...

      nof = MonarchObj.filtercount()

                  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

                      Next[B]

       

      Thanks in advance....

        • How to Set the Order   -  Filters
          Grant Perkins

          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.

           

          Grant

           

          Originally posted by yesb:

          Hi,

          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...

          nof = MonarchObj.filtercount()

                      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

                          Next[B]

           

          Thanks in advance.... /b[/quote]