Show file properties when file opened

[SteveG]

Is there a way of automatically showing the file properties when the
file is opened?

I want to avoid users having to go through the menu.

XLS '07 & XP

Many thanks

Steve

 

[Don Guillett Excel MVP]

Is there a way of automatically showing the file properties when the
file is opened?

I want to avoid users having to go through the menu.

XLS '07 & XP

Many thanks

Steve

Assign this to the WorkbookOpen event in the ThisWorkbook module
Sub showprop()
With ActiveWorkbook
MsgBox .BuiltinDocumentProperties("Author")
MsgBox .BuiltinDocumentProperties("Company")
MsgBox .BuiltinDocumentProperties("keywords")
End With
End Sub

 

[Gord Dibben]

Which properties do you want to see......summary, custom??

See Don's reply if you just want certain builtin properties.

Elsewise............to show the dialogbox

Private Sub Workbook_Open()
Application.Dialogs(xlDialogProperties).Show
End Sub

Or you may want just custom properties. Not clear from your description.


Gord Dibben MS Excel MVP

 

[GS]

SteveG brought next idea :

Is there a way of automatically showing the file properties when the
file is opened?

I want to avoid users having to go through the menu.

XLS '07 & XP

Many thanks

Steve

Do you mean file properties OR DocumentProperties for the file?

 

[SteveG]

Do you mean file properties OR DocumentProperties for the file?

DocumentProperties. The equivalent manual operation is Office button >
Prepare > Properties. Ideally I would like to put this in a template
file so that all documents that are created from this source behave in
the same way.

Steve

 

[SteveG]

.... but it is likely that custom properties will get added over time.

 

[GS]

SteveG explained on 1/11/2011 :

DocumentProperties. The equivalent manual operation is Office button >
Prepare > Properties. Ideally I would like to put this in a template
file so that all documents that are created from this source behave in
the same way.

Steve

What shows here is the file properties as found on the Summary tab of
the Properties dialog when you right-click the file in WE. To toggle
this on/off use:

CommandBars.ExecuteMso "FileProperties"

You want to note that as of the release of Vista, Windows no longer
supports these properties.

 

[GS]

GS submitted this idea :

You want to note that as of the release of Vista, Windows no longer supports
these properties.

I meant 'FileProperties' here. What Excel is doing is populating
DocumentProperties using the FileProperties format. Somewhat confused?
The window that displays provides fields where you can enter these
values as 'DocumentProperties', thus the window's title. These will
appear on the 'Details' tab of the properties dialog. Note that the
'Keywords' field appears in the 'Tag' field in the properties list.

In Excel v11 and earlier, invoking the properties dialog displayed the
same as what you get when you right-click and select 'Properties' in
Windows Explorer. Not the case in later versions. Seems someone on the
Excel dev team got lazy when they configured this feature!