insert live data

K

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...
 
B

Bill Foley

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

Karla V

Bill,

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

Thanks -
 
B

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."
 
S

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.
 
K

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...
 
B

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.
 
K

Karla V

Problem solved - thanks again!


Bill Foley said:
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/
 
B

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
 
K

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.
 

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

Top