Show file properties when file opened

  • Thread starter Thread starter SteveG
  • Start date Start date
S

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
 
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
Click to expand...

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
 
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
 
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
Click to expand...

Do you mean file properties OR DocumentProperties for the file?
 
Do you mean file properties OR DocumentProperties for the file?
Click to expand...

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 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
Click to expand...

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 submitted this idea :
You want to note that as of the release of Vista, Windows no longer supports
these properties.
Click to expand...

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!
 
Back
Top