VBA, Creating and Searching by Custom Properties

Creating and Searching by Custom Properties

Author	Message
Bob Duke #1 / 3	Creating and Searching by Custom Properties I'm relatively inexperience with VBA, but I'm researching how to: 1) Create a custom Properties form to save with a document 2) Create a Search form that will allow users to easily filter and sort search results according to fields and values in the custom Properties form. If you know of any out of the box document management solutions that aren't too expensive and provide similar functionality, this information is appreciated. Thanks in advance. Bob Dukes
Mon, 11 Jul 2005 07:16:33 GMT

Jonathan Wes #2 / 3	Creating and Searching by Custom Properties Hi Bob I don't know of any cheap out-of the box solutions, bit I've listed a few places that will help if you decide you want to grow your own. Quote: > I'm relatively inexperience with VBA, but I'm researching how to: > 1) Create a custom Properties form to save with a document Two things to take a look at How to create a Userform http://www.mvps.org/word/FAQs/Userforms/CreateAUserForm.htm How to use a single VBA procedure to read or write both custom and built-in Document Properties http://www.mvps.org/word/FAQs/MacrosVBA/MixedDocProps.htm Quote: > 2) Create a Search form that will allow users to easily filter and sort > search results according to fields and values in the custom Properties form. You want to take a look at two items 1. The FileSearch object in the Word VBA help file. This allows you to seach for documents based on a combination of properties. 2. This article might also be useful, if you want to list files and include properties Getting access to the Document Properties of a Word file http://www.mvps.org/word/FAQs/MacrosVBA/DSOFile.htm -- Regards Jonathan West - Word MVP MultiLinker - Automated generation of hyperlinks in Word Conversion to PDF & HTML http://www.multilinker.com Word FAQs at http://www.multilinker.com/wordfaq Please post any follow-up in the newsgroup. I do not reply to Word questions by email
Mon, 11 Jul 2005 20:07:35 GMT

Bob Duke #3 / 3	Creating and Searching by Custom Properties Thanks, Jonathan. I'll take a look at the links you posted and see if I can figure something out. Bob Hi Bob I don't know of any cheap out-of the box solutions, bit I've listed a few places that will help if you decide you want to grow your own. Quote: > I'm relatively inexperience with VBA, but I'm researching how to: > 1) Create a custom Properties form to save with a document Two things to take a look at How to create a Userform http://www.mvps.org/word/FAQs/Userforms/CreateAUserForm.htm How to use a single VBA procedure to read or write both custom and built-in Document Properties http://www.mvps.org/word/FAQs/MacrosVBA/MixedDocProps.htm Quote: > 2) Create a Search form that will allow users to easily filter and sort > search results according to fields and values in the custom Properties form. You want to take a look at two items 1. The FileSearch object in the Word VBA help file. This allows you to seach for documents based on a combination of properties. 2. This article might also be useful, if you want to list files and include properties Getting access to the Document Properties of a Word file http://www.mvps.org/word/FAQs/MacrosVBA/DSOFile.htm -- Regards Jonathan West - Word MVP MultiLinker - Automated generation of hyperlinks in Word Conversion to PDF & HTML http://www.multilinker.com Word FAQs at http://www.multilinker.com/wordfaq Please post any follow-up in the newsgroup. I do not reply to Word questions by email
Tue, 12 Jul 2005 05:21:41 GMT

Page 1 of 1

[ 3 post ]