cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

How to read Metadata-custom-properties and write them in a textbox?

SeeBear
1-Newbie

How to read Metadata-custom-properties and write them in a textbox?

Hej,

little question, please.... i can´t find my question in the MC-help....

With the script of a textbox like this:

Sub TextBoxEvent_Exec(Inputs,Outputs)

TextBox.Text = Worksheet.Metadata.Revision

textbox.appearance=0

i can read the regular Metadata out of the FilePropertyWindow.

But what is the right expression for reading the entries in "CustomProperties" ?tt.jpg

Thanks for help.

1 ACCEPTED SOLUTION

Accepted Solutions

Hej,

Thanks StuartBruff....

in my case:

textbox.text = worksheet.metadata.customitems.item(2) ' Darstellung 3. Eintrag in der "Benutzerdefinierten Dateieigenschaft"

additional help:

http://www.ptc.com/WCMS/files/129628/en/Mathcad_-_custom-controls13.pdf

View solution in original post

2 REPLIES 2
StuartBruff
23-Emerald II
(To:SeeBear)

R. Lampert wrote:

Hej,

little question, please.... i can´t find my question in the MC-help....

With the script of a textbox like this:

Sub TextBoxEvent_Exec(Inputs,Outputs)

TextBox.Text = Worksheet.Metadata.Revision

textbox.appearance=0

i can read the regular Metadata out of the FilePropertyWindow.

But what is the right expression for reading the entries in "CustomProperties" ?

Thanks for help.


TextBox.Text = worksheet.metadata.customitems.count

Outputs(0).Value = TextBox.Text

Hej,

Thanks StuartBruff....

in my case:

textbox.text = worksheet.metadata.customitems.item(2) ' Darstellung 3. Eintrag in der "Benutzerdefinierten Dateieigenschaft"

additional help:

http://www.ptc.com/WCMS/files/129628/en/Mathcad_-_custom-controls13.pdf

Top Tags