3 Replies Latest reply: Aug 5, 2015 8:56 PM by Tiago Hubner RSS

    ActiveDocument.field("foobar").GetPossibleValues

      ActiveDocument.Fields("Contract_Partner").GetPossibleValues don't return all values which are displayed in the list box.

      When I call  the missing value ActiveDocument.Fields("Contract_Partner").Select "foobar", the exports works well.

       

      Any hints?

       

      Thanks for your time!

       

      cheers

      Martin

       

      <snip>

      ActiveDocument.ClearAll true
      set val=ActiveDocument.Fields("Contract_Partner").GetPossibleValues
      
      for i=0 to val.Count-1
           msgbox(val.Item(i).Text)
           set MyTable = ActiveDocument.GetSheetObject("CH918")
           ActiveDocument.Fields("Contract_Partner").Select val.Item(i).Text
           MyTable.ExportBiff  "C:\" & val.Item(i).Text &"_export" & ".xls" 
      next
      

      </snip>