insert live data

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

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

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

"Karla V" wrote in message
...
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,

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

Thanks -

"Bill Foley" wrote:

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

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

"Karla V" wrote in message
...
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...

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

"Karla V" wrote in message
...
Bill,

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

Thanks -

"Bill Foley" wrote:

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

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

"Karla V" wrote in message
...
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...

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.


--
Regards,
Shyam Pillai

Handout Wizard: http://skp.mvps.org/how


"Karla V" wrote in message
...
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,

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" wrote:

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

"Karla V" wrote in message
...
Bill,

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

Thanks -

"Bill Foley" wrote:

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

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

"Karla V" wrote in message
...
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...

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/
Check out Word FAQs at: http://word.mvps.org/FAQs/General/index.htm

"Karla V" wrote in message
...
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" wrote:

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

"Karla V" wrote in message
...
Bill,

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

Thanks -

"Bill Foley" wrote:

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

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

"Karla V" wrote in message
...
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...

Problem solved - thanks again!


"Bill Foley" wrote:

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/
Check out Word FAQs at: http://word.mvps.org/FAQs/General/index.htm

"Karla V" wrote in message
...
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" wrote:

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

"Karla V" wrote in message
...
Bill,

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

Thanks -

"Bill Foley" wrote:

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

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

"Karla V" wrote in message
...
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...

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

On Fri, 4 Mar 2005 10:55:08 -0800, "Karla V"
wrote:

Bill,

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

Thanks -

"Bill Foley" wrote:

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

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

"Karla V" wrote in message
...
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...

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.



" wrote:

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

On Fri, 4 Mar 2005 10:55:08 -0800, "Karla V"
wrote:

Bill,

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

Thanks -

"Bill Foley" wrote:

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

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

"Karla V" wrote in message
...
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...