View Single Post
 
Old 04-28-2024, 09:26 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,159
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Your earlier post mention that these 'custom properties' are coming from Sharepoint. If that is the case, this is far more complex than just gathering a list of the custom properties. To VBA, a custom property resides in a different area of a document structure than the custom XML files.

I replied to that earlier post and would recommend you actually explore doing this in Sharepoint by playing around with a view which includes the fields you are interested in updating. If you get the view right you can either:
- 'Export to Excel' to get the complete file list and the properties you wanted.
or
- Use a Table view to bulk-update the fields without ever leaving Sharepoint
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote