Reading files from Excel

Scripting Forums AppleScript | Mac OS X
,
#1

I have this Applescript that reads in a sales order number from Excel but apparent it does not work in the latest version of Excel. Is there something wrong with my code? Here is the code:

repeat
tell application “Microsoft Excel”
–Activate
set currRow to row of selection as string
set currColumn to column of selection as string
set theOrder to «class pfor» of selection as string
end tell
set {text:currRow} to currRow as string
set {text:currColumn} to currColumn as string
set {text:theOrder} to theOrder as string
if theOrder = “” then
activate
display dialog “The script is finished” buttons {“OK”} default button “OK”
return – stops entire script
end if

#2

See the “«class pfor»” part? That’s the problem. What does the script say there when you open it with the old version of Excel? What version number is the new Excel?

#3

The script works fine in Excel X, but Excel 2004 I get the error message, “Some of the data could not be read”.

Thanks!
Bill

#4

See the “«class pfor»” part? That’s the problem.

What does the script say there when you open it with Excel X?

#5

When I run in Excel X it works like a charm. It runs its process.