If I have a list of files in a column of an Excel spreadsheet, has anyone used VBA to do some routine edits to a .jpg?
What I am looking for is to do two things. One is to change the size, (example would be a 900 x 600 pixel .jpg down to a 300 x 150) and the other is to get a general RGB number or a general color number that the image produces, added to a column in Excel or to appended it to the file name when resaving.
Has anyone used VBA on an excel list, to open a file in a different program, like Photoshop or one that could get us the data needed, adj it and resave it? Do it again for the next one in the list... etc.
Looking for some direction.. The file attached was provided by this Excel area, and works nicely to rename a list of files from a specific folder. It contains the folder path to save back to after the two tasks above are completed, but to do this for over 20K files would took weeks, perhaps months.
Please advise and thanks. -R-