WD: WordBasic Examples: TableSortAToZ, TableSortZToA

ID: Q106329

The information in this article applies to:

SUMMARY

This article contains a sample macro that demonstrates the use of the following WordBasic statements or functions:

   TableSortAToZ

   TableSortZToA

This article supplements the information in online Help. To open this Help topic in Word for Windows, click Contents on the Help menu and then choose the "Programming with Microsoft Word" topic. In Word for the Macintosh, click the Help icon, select Microsoft Word Help and choose the "Programming with Microsoft Word" topic.

MORE INFORMATION

Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact the Microsoft fee-based consulting line at (800) 936-5200. For more information about the support options available from Microsoft, please see the following page on the World Wide Web:

   http://www.microsoft.com/supportnet/refguide/ 

TableSortAToZ

TableSortZToA

Syntax:

TableSortAToZ TableSortZToA

Example:

This sample macro inserts a table and places letters in each cell. It sorts the letters in ascending and then descending order.

   Sub MAIN
      If SelInfo(27) - - 1 Then FileNewDefault
      TableInsertTable .ConvertFrom - "", .NumColumns - "1", .NumRows - \ 
      "8", .InitialColWidth - "3" + Chr$(34), .Format - "0", .Apply - "167"
      Insert "This is the table heading and will not be sorted."
      NextCell
      Insert "B"
      NextCell
      Insert "D"
      NextCell
      Insert "E"
      NextCell
      Insert "F"
      NextCell
      Insert "A"
      NextCell
      Insert "G"
      NextCell
      Insert "C"
      MsgBox "Ascending Sort"
      TableSelectTable
      TableSortAToZ
      MsgBox "Descending Sort"
      TableSelectTable
      TableSortZToA
      EndOfDocument
   End Sub

Additional query words:
Keywords          : kbprg kbdtacode wordnt kbmacroexample ntword macword word6 word7 word95 
Version           : WINDOWS:6.0,6.0a,6.0c,7.0,7.0a; MACINTOSH:6.0,6.0.1,6.0.1a
Platform          : MACINTOSH WINDOWS
Issue type        : kbhowto

Last Reviewed: April 9, 1999