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

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!

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

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?


I would select the column in excel.