See attached spreadsheet. I have an old file name, column E, and a new file name in Column D, that when run it changes all the filenames in that directory/folder to whatever is in column D. This is to rename file to more of a consistent naming convention.
My question, has to do with PhotoShop because each of these new filenames are going to be ,pdf files and have a specific pixels size. What I was wondering if we can do is, with code, script a macro or something that would open each file in column D, starting in row two, open the file, set a new pixel size, (same for all files), then resave it to the same folder path and filename. Going down the list until all .pdf files have been chg'ed.
I would like an input box to declare the new size that would be applied to all files.
Have you ever heard this done and can this be automated to edit each file in column D? Lets just say that there are so many files that it would take me weeks to do these manually.
I need to know some specifics too, I do not have PhotoShop, but I do have SnagIt. Can this run in Excel and have Excel access PhotoShop (when I get it). Just wondering what my options are to automating such a task, and if PhotoShop can do this? or do I need to look at possibly a different solution to do this task.
Please advise and thanks. -R-