I am a designer who starts my jobs by giving them a job number, date and name in an Excel spreadsheet. From there, I create a folder inside the client’s folder with the name, in this order, “Job Number” “Name” “Month and Year”
For Example
Excel would look like
1234F 02/06/11 Brochure Promoting Project 360
My job folder would look like this
1234F Brochure for 360 Project 0211
Inside that folder, I have four subfolders
and then I set the label to yellow to show it is a new job (and then change it as the project progresses)
I have been able to grab text from one cell in Excel and create a folder with that name and I have been able to create a folder containing subfolders (by copying other, researching, guessing, cussing). It has been a fun challenge, but I can’t seem to get exactly what I want.
Here is what I have so far
set destinationFolder to (choose folder with prompt “Choose Folder”)
tell application “Microsoft Excel”
set theCells to value of (get selection)
end tell
repeat with oneCell in theCells
tell application “Finder”
set main_folder to (make new folder with properties {name:theCells})
set root_folder2 to make new folder at main_folder with properties {name:" Design"}
set root_folder3 to make new folder at main_folder with properties {name:" PDFs"}
set root_folder4 to make new folder at main_folder with properties {name:“Art”}
set root_folder5 to make new folder at main_folder with properties {name:“Text”}
set root_folder5 to make new folder at main_folder with properties {name:“Final Files”}
end tell
end repeat
Thanks for any help and for helping me learn Applescript.
cindy in indy