Re: [macwiz] quick way to rename pics?
Re: [macwiz] quick way to rename pics?
- Subject: Re: [macwiz] quick way to rename pics?
- From: Yosemite <email@hidden>
- Date: Fri, 12 Jan 2001 12:22:30 -0900
-- something like the following will work, sure
-- you will need to change a few things but ...
(* if column A contains names and
column B contains the number
*)
set i to 1
repeat 545 times
tell application "Microsoft Excel"
set student to Value of Cell ("$A$" & i as string)
set sNum to Value of Cell ("$B$" & i as string)
end tell
tell application "Finder" to set name of file ,
("machd0:desktop folder:temp:" & i & ".jpg") to ,
student
set i to i + 1
end repeat
-- hcir
mailto:email@hidden
>
I'm forwarding this from another list. I assume he's using Excel 98, but I
>
don't know for sure. I have little scripting experience, and none involving
>
spreadsheets. Any help is greatly appreciated.
>
>
>>> Hi,
>
>>> I've got 545 Jpegs that are named with numbers. I have a spreadsheet
>
>>> that lists the numbers with the associated student names. I want to
>
>>> know if there is a quick way to have the computer rename each picture
>
>>> with the student name (instead of the number).
>
>>> I used GraphicConverter Batch to trim each picture, but I didn't see
>
>>> a way to do the renaming....any ideas?
>
>>> I don't have a lot of experience with scripting, but if anyone out
>
>>> there has a script I could use, that'd be great....thanks..
>
>>> -Joe
>
>>> Thanks,