Word Document.variables - any equivalent in Excel, Powepoint? 1

[DrSimon]

The subject pretty well says it. I've been using Document variables in Word to 'hide' variable data. Is there any equivalent in Excel or PowerPoint?

Thanks
Simon

 

[PHV]

In Excel you may use the WorkSheet.CustomProperties collection.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DrSimon]

Thanks. Not really PHV - I'm after a Workbook level property

Simon

 

[PHV]

So, use the Workbook.CustomDocumentProperties collection.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

You may use it in Powerpoint and Word as well.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[combo]

In case of excel the Names collection is similar to word's Variables.

combo

 

[DrSimon]

Thanks - all good ideas that I'm afraid I have already considered. The good thing about Word Document variables is that they are hidden unless you write some code to look for them.

 

[mintjulep]

For Excel consider using cells on a xlVeryHidden worksheet.

 

[combo]

It is possible to hide name in excel (VariableStoringName.Visible=False).

combo

 

[DrSimon]

That's well thought out combo - I didn't think of that. I've still got PowerPoint to think about, but can't give you a half-star, so I'll round it up .
Anyone else any thoughts about PowerPoint? Shame you can't make a CustomDocumentProperty invisible.
Simon

 

[combo]

Thanks for the half-star deserved, maybe the hint of applying Tags collection in powerpoint to store text will fit the ruunding up. Tags are saved with presentation and are quite flexible, have no user interface and can be assigned to presentation, slide or shape.

combo

 

[strongm]

Have you considered SaveSetting and GetSetting?

 

[DrSimon]

strongm - not heard of either, but neither really what I wanted. It's not the application level, but the object being opened - Presentation in the case of PowerPoint.

combo however... you've come up trumps again. The first site I looked at said this: 'Tags are a very useful feature and often overlooked by vba programmers.' I don't disagree, apart from the fact that you didn't overlook them. Tags seem to be pretty close to Word Variables, though I don't see why there is a 'Variable' object in Word but no 'Tag' object in PowerPoint. This is worth more than one star! So 2 stars for answering both my questions seems well earned.
Many thanks
Simon