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.
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.