Simple Data Sort in Excel using Applescript

Scripting Forums AppleScript | Mac OS X
#1

Hi, I’m new to Applescripts and just want to create some very basic scripts to SORT DATA in Excel 2008. Can anyone please show me the simple script commands to do something like this:

  1. select a particular EXCEL workbook and worksheet
  2. select specific cells and columns
  3. sort them into order (ascending or descending)

Many thanks.

Marsy - UK Mac novice

#2

Hi marsy,

Page 372 of the excellent MS Excel AppleScript Reference features some example code.

Also MacTech’s VBA to AppleScript Guide has a good section about sorting with AppleScript.

HTH!

#3

Thanks Martin… gave me a good starting point… I am now trying to learn a bit more… :slight_smile: