AppleScript for Excel to select/copy all cells?
found this on Macscripter.net I think it is what you are looking for:

tell application "Microsoft Excel"
   tell active sheet
       select used range
   end tell
end tell