File Properties.

[Kid_Coke]

Here it is gang,

Maybe this doesn't belong in this forum, but I was wondering how can I modify a files properties? For example ... when a user saves a new copy of my VBA application (excel) the department value is set to "MY DEPARTMENT". That way when anyone right clicks on the file and goes to the properties ... the department value is "MY DEPARTMENT".

Also ... where is that data stored?


I know this is kind of confusing, but lets see where this one goes.

Thanks.

Kid Coke

[Psyrus]

CustomDocumentProperties. You can access the value of each like this:

CustomDocumentProperties.Item("Department")
CustomDocumentProperties("Department")

[Kid_Coke]

Psyrus,

Thanks for the information.

So I can use that code in a button click event? Can I add as many file properties as I like?

Thanks.

[Psyrus]

I am not sure what the max limit is, but this is how you add it in code:

CustomDocumentProperties.Add Name:="Department", LinkToContent:=False, Type:=msoPropertyTypeString, Value:="Department One"

[Kid_Coke]

Nice ... This is turning out to be a very cool project.

Now ... here is the question ... Where is that information actually stored? Is it in some table (a la FAT32) .. or is it part of the file itself ...

Any info would be appreciated.

[Psyrus]

It's part of the file itself.