Prompting for Document Properties

[Jeremy]

I have Word 2000 templates that need to prompt for users to check (or enter) the document properties. The user/office/document properties vary from Project to Project and users never seem to review them unless prompted to do so. Is there a way to prompt them to check or enter these details

 

[Beth Melton]

Hi Jeremy,

If the users are creating new documents based on the template then
place the following macro in the "ThisDocument" module for the
template:

Sub Document_New()
On Error Resume Next
Application.Run "FileProperties"
End Sub


--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

I have Word 2000 templates that need to prompt for users to check

(or enter) the document properties. The user/office/document
properties vary from Project to Project and users never seem to review
them unless prompted to do so. Is there a way to prompt them to check
or enter these details?

 

[Jeremy]

Thank you Beth for this. It has worked (when I figured out what the 'ThisDocument' Module was :-

The next question though is whether it is possible to bring up the properties defaulting to the summary tab rather than general

 

[Beth Melton]

Hi Jeremy,

The File Properties dialog box is hard to control through VBA since it
is more of a Windows system dialog box rather than a Word dialog box.

They don't include an access key for the tab so you can't use SendKeys
to select the appropriate tab, Word will remember the last active tab
and you can not rely on a specific tab as the default, so something
like:

On Error Resume Next
SendKeys "^{TAB}"
Application.Run "FileProperties"

Is unreliable.

If you need just the summary information then perhaps this will work
instead:

With Dialogs(wdDialogFileSummaryInfo)
.Show
End With

If this will not work then you might try posting to one of the Word
VBA newsgroups. Perhaps one of the gurus there will have figured out
this beast.
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

Thank you Beth for this. It has worked (when I figured out what the 'ThisDocument' Module was

The next question though is whether it is possible to bring up the

properties defaulting to the summary tab rather than general.

 

[Jeremy]

Beth

Thank you so much. This is exactly what I was looking for. So far macros have been a dark and mysterious back room that I have never delved in to, but with your little bit of help, I think it's something I will see the potential for more obsurities

Many many thanks for your time and efforts

Jerem

 

[Beth Melton]

Hi Jeremy,

Well, now that you see this potential then I'll bet you are excited to
learn more! <grin>

Here's a great place to start:
http://www.mvps.org/word/FAQs/MacrosVBA/index.htm

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

Beth,

Thank you so much. This is exactly what I was looking for. So far

macros have been a dark and mysterious back room that I have never
delved in to, but with your little bit of help, I think it's something
I will see the potential for more obsurities.