Displaying the Custom Tab in File Properties in Excel

[taylo40]

Hello,

In Microsoft Word, when you add items to the "Custom" tab within File Properties. The user can then get these variables to be printed in the Word Document.

Does the same functionality exist in Excel ?

Regards,

Jamie

 

[GlennUK]

I doubt it, but if you describe what items you'd like maybe something could be done.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[taylo40]

Hello,

Within the custom tab, I have selected the following variables:-

Owner
Document Number
Status

For the above, I have selected the "Type" as Text and then entered a value.

My question is, can I enter those values into a cell in Excel ?

For example, the users of the spreadsheet will be able to see the owner of the spreadsheet and the current versio..

Regards,

Jamie

 

[cheerio]

This can easily be achieved by writing a simple VBA user defined function. For example, thisworkbook.CustomDocumentProperties("owner") would return the owner custom property.

If you need help on VBA repost in VBA Visual Basic for Applications (Microsoft).