Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-28-2024, 09:26 PM
Guessed's Avatar
Guessed Guessed is offline Help with Excel macro to extract all custom properties of Word Document to later mass update Windows 10 Help with Excel macro to extract all custom properties of Word Document to later mass update Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to extract Excel data for Word Macro? syl3786 Word VBA 0 10-17-2023 08:57 PM
Help with Excel macro to extract all custom properties of Word Document to later mass update Phantom fields (custom document properties)- where do they come from - and how can they be stopped?! andiekit Word 13 03-18-2021 07:02 AM
Help with Excel macro to extract all custom properties of Word Document to later mass update sort custom document properties LQuinn Word VBA 4 03-17-2021 05:19 PM
Help with Excel macro to extract all custom properties of Word Document to later mass update Adding Custom Document Properties NicoleJones Word VBA 3 03-10-2021 08:43 PM
Macro to extract bookmarked data from Word document and insert into another Word Document VStebler Word VBA 3 05-03-2018 05:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft