PPT VBA - where do I store config data?

J

Jason

I am a long-time VBA programmer for Excel...and am used to using hidden
sheets to store my configuration type info that I use in the VBA program.
This way every time the file is opened the config can easily be read from a
hidden sheet to change the way in which the VBA acts.

I just started programming for PowerPoint and am at a loss for how to best
store this temporary data/config. Do I just use hidden text boxes that
contain config info that I can read?

Thanks!
 
C

ChrisHarrington

you can put tags on slides and on shapes - probably will for for your
situation
 
B

Bill Dilworth

I agree, Tags are the best method. They can also be attached at the
presentation level. These are especially useful at keeping data available
when the slides are being swapped in and out.

The downside is that they are a little harder to visualize. Instead of
making the hidden sheet visible, you'll need to write a few lines of code to
list the tags you are using - no big deal.

Most users do not know that they exist, let alone how to access them, so the
data should be fairly secure against newbie's delete keys.


--
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
vestprog2@ Please read the PowerPoint FAQ pages.
yahoo. They answer most of our questions.
com www.pptfaq.com
..
 
A

Abhinav

Hi Chris,
I had created a VBA module in a .pptm file and unfortunately I have lost the
password, how do I remove the password? Please help this is very urgent
 
A

Abhinav

Hi Bill,
I had created a VBA module in a .pptm file and unfortunately I have lost the
password, how do I remove the password? Please help this is very urgent
 
J

Jason

Thanks to everybody who replied. Tags it is!



Steve Rindsberg said:
Ditto the other suggestions for tags. You might be tempted to use the
presentation's custom properties. Don't go there. Serious data limits, and
you'll end up stomping on somebody's links or their links'll stomp out your
data.

Tags give you virtually unlimited storage.

Example:

' Store some stuff in Presentation-level tags:
With ActivePresentation
.Tags.Add "SomeString", "Here is the tag value"
' all tags are strings; you'll have to convert
' 'em to numbers if need be
.Tags.Add "UniversalAnswer", "42"
End With

' Now do something with the tags:
With ActivePresentation
MsgBox "Some string:" & vbCrLf _
& .Tags("SomeString")
MsgBox "Two times the answer:" & vbCrLf _
& CStr(CLng(.Tags("UniversalAnswer") * 2))
End With


-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top