View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Alasdair Stirling[_3_] Alasdair Stirling[_3_] is offline
external usenet poster
 
Posts: 17
Default owner/author of a file

Document Properties (Builtin and Custom) are apply to the Workbook and not to
the indivdual worksheets within a workbook. The options that column options
that Windows Explorer offers you are linked to the Builtin Document
Properties and these document properties are common (but not identical)
accross the MS Office applications. Accordingly, you can wrie some VBA code
to set the document properties and then configure the Explorer window to
display those that you have written to the Office files.

Regards,

Alasdair Stirling

"Dennis Hancy" wrote:

Does Builtindocumentproperties only work on Excel worksheets within a
workbook?

The file listing I need to produce comes a user-specified folder name.
In Windows Explorer, I can choose a number of columns to display. As a
default, I get Name, Size, Type, and Modified. However, I have the
option of displaying other columns as well - including Owner and Author.

The files can be anything - not just Excel files.

Because I can display these properties within Windows Explorer, does
that mean I get to these properties via Excel VBA?

Thanks.


Dennis

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!