I have an excel workbook open, with old file names in column A and new file names in column B. I am attempting to use the applescript below to rename my files. It runs without errors, but doesn't rename the files. Am I missing something? Any help is much appreciated.
set theDirectory to "/Users/admin/Desktop/test/copied images" tell application "Microsoft Excel" tell active sheet tell used range set rc to count of rows end tell set theList to get value of range ("A1:B" & rc) as list repeat with theItem in theList try do shell script "mv " & theDirectory & "/" & quoted form of item 1 of theItem & space & theDirectory & "/" & quoted form of item 2 of theItem end try end repeat end tell end tell