Reply to thread

Message

<blockquote data-quote="MacGrunt" data-source="post: 1276547" data-attributes="member: 210105">G'dayI'm assuming you are trying to rename a bunch of files using one open excel spreadsheet as the source of the filenames — and that the new filenames are in column A (?)[CODE]set theFiles to choose file with multiple selections allowedset NewNames to {}--place enough values from excel file into a listtell application &quot;Microsoft Excel&quot;&nbsp; &nbsp; tell active sheet of active workbook&nbsp; &nbsp; &nbsp; &nbsp; repeat with x from 1 to count of theFiles&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; set end of NewNames to formula of cell (&quot;A&quot; &amp; x)&nbsp; &nbsp; &nbsp; &nbsp; end repeat&nbsp; &nbsp; end tellend tell--rename the filesrepeat with i from 1 to count of theFiles&nbsp; &nbsp; set NewName to item i of NewNames&nbsp; &nbsp; set ThisFile to item i of theFiles&nbsp; &nbsp; tell application &quot;Finder&quot;&nbsp; &nbsp; &nbsp; &nbsp; set name of ThisFile to (NewName &amp; &quot;.&quot; &amp; name extension of ThisFile)&nbsp; &nbsp; end tellend repeat[/CODE]i haven't tested what will happen if the script runs into an empty cell.you could also run this as a droplet instead by changing it like this : [CODE]on open theFiles&nbsp; &nbsp; -- delete the following line&nbsp; &nbsp; set theFiles to choose file with multiple selections allowed&nbsp; &nbsp; --add the rest of the scriptend open[/CODE]hope that helps a littlem.</blockquote>

[QUOTE="MacGrunt, post: 1276547, member: 210105"] [B]G'day[/B] I'm assuming you are trying to rename a bunch of files using one open excel spreadsheet as the source of the filenames — and that the new filenames are in column A (?) [CODE]set theFiles to choose file with multiple selections allowed set NewNames to {} --place enough values from excel file into a list tell application "Microsoft Excel" tell active sheet of active workbook repeat with x from 1 to count of theFiles set end of NewNames to formula of cell ("A" & x) end repeat end tell end tell --rename the files repeat with i from 1 to count of theFiles set NewName to item i of NewNames set ThisFile to item i of theFiles tell application "Finder" set name of ThisFile to (NewName & "." & name extension of ThisFile) end tell end repeat[/CODE] i haven't tested what will happen if the script runs into an empty cell. you could also run this as a droplet instead by changing it like this : [CODE]on open theFiles -- delete the following line set theFiles to choose file with multiple selections allowed --add the rest of the script end open[/CODE] hope that helps a little [B]m.[/B] [/QUOTE]

Verification

Name this item. 🍎