I am using Lightroom 6 and would love to be able to automate the metadata - keyword, subject, copyright, etc.... - in my files. I have all of the data in an Excel spreadsheet and have used VBA to automate this process using Photoshop CC2014 but, of course, the code doesn't work with Lightroom. Has anyone done this before? I have a large catalog that I need to start updating and I would love to have it run in the background while I am doing something else. I have done some searches in this forum and general web searches but find nothing relating to Lightroom - maybe it isn't possible.
Any ideas? Suggestions?