1-Visitor

Solved

How to use document properties inside the document

Forum|Forum|15 years ago
April 25, 2011
3 replies
9169 views

I want to use the document properties (author and title) and the file name of the Document and some custom defined properties to show them at the header of the document

(I want to use an embedded excelsheet to show the properties formated) and at the head line of each page.

At this time, I put a VBA script-object in the document, which reads the data using

Set metadata = worksheet.metadata

Set items = metadata.customitems

For each item in items

...

If (item.name = "m_discription") Then
Outputs(1).Value = item.value

End If

...

It works.

My questions:

-Is there another solution for referencing the meta-data inside the doc and inside the header and footer?

(As in Word, for example?)

-How can I get ,title' and ,author' from the builtin document properties and the filename?

Thanks,

H.Steffen

Statistics_Analysis

Best answer by RichardJ

At this time, I put a VBA script-object in the document, which reads the data using

As a minor technical point, it's not VBA, it's VBscript.

-Is there another solution for referencing the meta-data inside the doc and inside the header and footer?
(As in Word, for example?)

No. The only way to do this is via a VBscript.

-How can I get ,title' and ,author' from the builtin document properties and the filename?

Here's a function based on a scripted component that will get any metadata item. To get the filename requires another function based on a scripted component.

R

RichardJ

Answer

19-Tanzanite

At this time, I put a VBA script-object in the document, which reads the data using

As a minor technical point, it's not VBA, it's VBscript.

-Is there another solution for referencing the meta-data inside the doc and inside the header and footer?
(As in Word, for example?)

No. The only way to do this is via a VBscript.

-How can I get ,title' and ,author' from the builtin document properties and the filename?

Here's a function based on a scripted component that will get any metadata item. To get the filename requires another function based on a scripted component.

1_Get-Metadata-xmcdz.zip

2_Get-worksheet-path-and-name-mcd.zip

M

MikeArmstrong

1-Visitor

Nice worksheet.

Are you planning on putting your scripted components in the FAQ document?

Mike

R

RichardJ

19-Tanzanite

Are you planning on putting your scripted components in the FAQ document?

Yes, I agree that shod be one of the linked documents. A ot of the components that people ask for are already in that document.

F

Fred_Kohlhepp

23-Emerald I

Holger Steffen wrote:
I want to use the document properties (author and title) and the file name of the Document and some custom defined properties to show them at the header of the document
(I want to use an embedded excelsheet to show the properties formated) and at the head line of each page.
At this time, I put a VBA script-object in the document, which reads the data using
Set metadata = worksheet.metadata
Set items = metadata.customitems
For each item in items
...
If (item.name = "m_discription") Then
Outputs(1).Value = item.value
End If
...
Next
(I'm not familiar with VBA, I found this code lines in a forum)
It works.
My questions:
-Is there another solution for referencing the meta-data inside the doc and inside the header and footer?
(As in Word, for example?)
-How can I get ,title' and ,author' from the builtin document properties and the filename?
Thanks,
H.Steffen

You can't insert a Header (View/Header/footer) and insert file information in them? Version 11 allows this.

R

RichardJ

19-Tanzanite

You can't insert a Header (View/Header/footer) and insert file information in them? Version 11 allows this.

I had forgotten you can get the filename and path directly in the header. But in versions 12 and later, no, they did not add the capability of directly accessing the metadata.

F

Fred_Kohlhepp

23-Emerald I

Richard Jackson wrote:
You can't insert a Header (View/Header/footer) and insert file information in them? Version 11 allows this.
I had forgotten you can get the filename and path directly in the header. But in versions 12 and later, no, they did not add the capability of directly accessing the metadata.

Created in version 14, printed to pdf file for discussion.

1_Mathcad---junk.pdf

H

HolgerSteffen

Author

1-Visitor

Thank you very much.

I will implement that code next time i my form!

M

MikeArmstrong

1-Visitor

If you are looking for scripted components similar to the examples posted here try searching for Extra Components, created by Richard, also Phillip Oakley created a good sheet with many useful functions.

Mike