insert live data

[Karla V]

Is there any way to insert live data during a presentation? For example,
while in Slide Show mode, can I enter sales numbers and then have them
calculate?

Thanks for any suggestions you can offer...

 

[Bill Foley]

You can with VBA code. I have a simple calculation slide sample I can send
you if you wish.

 

[Kurt]

Or use DataPoint from www.take-off.as

Kurt

 

[Karla V]

Bill,

I am not very familiar with code, but if you could send the slide that would
be a great start.

Thanks -

 

[Bill Foley]

Sorry, I should have mentioned that I needed an address to send the file to.
Never mind. I went ahead and added a page to my FAQ web page. You can read
about and download the file at:

http://www.pttinc.com/ppt_faq8.html

Holler back if you have any questions.

--
Bill Foley, Microsoft MVP (PowerPoint)
Microsoft Office Specialist Master Instructor
www.pttinc.com
Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/
"Success, something you measure when you are through succeeding."

 

[Shyam Pillai]

Karla,
Looking for an Excel like interface? If you have PPT 2002/2003 then insert a
Microsoft Office Spreadsheet component on the slide. During slide show you
will be able to input and perform calculations live.

 

[Karla V]

Bill,

Thanks! This is exactly what I was looking for. One question...when I
opened your PPT file, the command buttons didn't work. So, I created a new
file, copied the code to the new buttons and everything worked great.

I've now e-mailed my PPT file internally to another department and the
buttons do not work again. Any idea what is happening? It seems like the
code isn't following the presentation.

Thanks again...

 

[Bill Foley]

You MUST set your security down from HIGH or VERY HIGH to MEDIUM. If you
merely copy slides or objects from one file to another, the Module of code
does not go with it. You could click ALT+F11 to enter the VBE window, click
on and drag the Module from the one project to another.

However, I imagine if you had set your security (or others set theirs also)
to MEDIUM, all would be fine.

 

[Karla V]

Problem solved - thanks again!

You MUST set your security down from HIGH or VERY HIGH to MEDIUM. If you
merely copy slides or objects from one file to another, the Module of code
does not go with it. You could click ALT+F11 to enter the VBE window, click
on and drag the Module from the one project to another.

However, I imagine if you had set your security (or others set theirs also)
to MEDIUM, all would be fine.

--
Bill Foley, Microsoft MVP (PowerPoint)
Microsoft Office Specialist Master Instructor - XP
www.pttinc.com
Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/

 

[brian]

Karla,
You can also do this without VBA,
View Controls Toolbox toolbar. Use the Microsoft Office Spreadsheet
ActiveX control. You can make it do live calculations in slide show
mode. The formulas you write in slide show mode are saved and activate
the next time you are in slide show view
Brian Reilly PowerPoint MVP

 

[Karla V]

Thanks, Brian. Another great solution. I like the professional look of the
text boxes/command buttons, but the Excel worksheet is definitely a quick and
simple solution I know I'll be able to use as well.

Is there anything out there that details what all of the Active X controls
do? I work in Access a lot, but don't use these particular tools very often.