How to batch file names changing in finder, from Excel column of names?

[dbetanc]

I’d like to make a Macro that reads and copy 2 columns from Excel and paste it into the File Name and File Comments in the finder. Basically, I have an Excel Document with filenames column and descriptions column, that I need to change in the finder to a large number of files, changing the File Name, and Adding File Comments. I’m trying to figure it out and it seems simple, but I can’t. Would you guide me in how to do this? Thanks!

[cfriend]

This thread might be a good starting point re: comments on files.

Add Comment to a File -- Desktop/Finder/PathFinder

I have been trying to figure out if it is possible to add a comment to a file that is selected on/in the Desktop, Finder, or Pathfinder. I would like to trigger a macro to ask for user input and apply it as a comment to the selected file or a selection of files. Can anyone give me a few suggestions if this is possible. I do have the Path Finder » Set Tags of Selected Items to Red to build upon so I think with some modification this macro could be tweaked to accomplish what I want. Better yet t…

[ccstone]

Hey Daniel,

How are you going to access the Excel workbook?

Are you going to make a selection?

Or are you wanting to access the given columns wihtout manually making a selection?

-Chris

[dbetanc]

I would select the column in excel.