ok i have a macro that when run will create a bunch of custom properties get the info and assign it to the respective properties. what i need to know is how to check if a custom property that already exist that is set to "text" has any value or if it is left blank. for example:
Property Name Type Value/ Text Expression
Part Number Text ABC123
Part Number Text
so in this example if it shows ABC123 then move to next property but if it shows nothing then fill in the field with the file name.