Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

DrSimon

IS-IT--Management
Dec 14, 2001
674
GB
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
 
In Excel you may use the WorkSheet.CustomProperties collection.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Thanks. Not really PHV - I'm after a Workbook level property

Simon
 
So, use the Workbook.CustomDocumentProperties collection.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
You may use it in Powerpoint and Word as well.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
In case of excel the Names collection is similar to word's Variables.

combo
 
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.
 
It is possible to hide name in excel (VariableStoringName.Visible=False).

combo
 
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 [2thumbsup].
Anyone else any thoughts about PowerPoint? Shame you can't make a CustomDocumentProperty invisible.
Simon
 
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 - 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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top