Placing an ID into a Photo Tag

[lwkochis]

Hi,

I have an excel spreadsheet and in column A lists the photo name, such as Smith, John.jpg and so forth. In column B, I have the ID that is assoicated with that photo name. Each ID is different and there are never two ID's that are the same for a photo name.

The goal is to have excel go into the folder that houses these photos and put the ID (column B) in the Tag of each photo. (If you right click on a photo, you will select properties and then a tag will appear to enter value.)

Is there a way to do this in an excel macro?

Thanks.

Lucas

 

[lwkochis]

Hi,

So to elaborate more about my request, I think the trick is using the BuiltinDocumentProperties for this. Any suggestions?