Importing Excel Data into PowerPoint Textboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I have an Excel spreadsheet containing about 800 records. Each record contains a first name (column 1), last name (column 2), City (column 3) and State (column 4). Each record will appear on a PowerPoint frame (this is for an awards ceremony). I am not a programmer, but would like to somehow automate the importing of this data into PowerPoint. In looking through the posts here, Bill Dilworth's post on 3/12 seemed to be a start in the right direction, but I could not get it to work. Any ideas

Thanks in advance

Amy
 
Amy,
I you really want to automate this without coding: www.take-off.as/datapoint
With that add-on I think your work is completed in 5 minutes.
Kurt

AmyM said:
Hello,
I have an Excel spreadsheet containing about 800 records. Each record
Click to expand...
contains a first name (column 1), last name (column 2), City (column 3) and
State (column 4). Each record will appear on a PowerPoint frame (this is for
an awards ceremony). I am not a programmer, but would like to somehow
automate the importing of this data into PowerPoint. In looking through the
posts here, Bill Dilworth's post on 3/12 seemed to be a start in the right
direction, but I could not get it to work. Any ideas?
 
[CRITICAL UPDATE - Anyone using Office 2003 should install the critical
update as soon as possible. From PowerPoint, choose "Help -> Check for
Updates".]

Hello,

PowerPoint does not provide that level of integration with other Office
applications. To get that kind of integration you would have to write your
own solution (e.g. VBA) or find some 3rd party solution already developed.

If you (or anyone else reading this message) thinks that is important for
PowerPoint to provide better (or any) support for support for consuming,
viewing and/or interacting with data and documents from other Office
applications (without having to resort to VBA or add-ins), don't forget to
send your feedback (in YOUR OWN WORDS, please) to Microsoft at:

http://register.microsoft.com/mswish/suggestion.asp

As with all product suggestions, it's important that you not just state
your wish but also WHY it is important to you that your product suggestion
be implemented by Microsoft. Microsoft receives thousands of product
suggestions every day and we read each one but, in any given product
development cycle, there are only sufficient resources to address the ones
that are most important to our customers so take the extra time to state
your case as clearly and completely as possible.

IMPORTANT: Each submission should be a single suggestion (not a list of
suggestions).

John Langhans
Microsoft Corporation
Supportability Program Manager
Microsoft Office PowerPoint for Windows
Microsoft Office Picture Manager for Windows

For FAQ's, highlights and top issues, visit the Microsoft PowerPoint
support center at: http://support.microsoft.com/default.aspx?pr=ppt
Search the Microsoft Knowledge Base at:
http://support.microsoft.com/default.aspx?pr=kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
 
Hello,
I have an Excel spreadsheet containing about 800 records. Each record contains a
Click to expand...
first name (column 1), last name (column 2), City (column 3) and State (column 4).
Each record will appear on a PowerPoint frame (this is for an awards ceremony). I
am not a programmer, but would like to somehow automate the importing of this data
into PowerPoint. In looking through the posts here, Bill Dilworth's post on 3/12
seemed to be a start in the right direction, but I could not get it to work. Any
ideas?
Another approach: http://merge.pptools.com
(it's an inexpensive commercial addin; free demo available)
 
Thanks, Steve. I'll try the demo

Am

----- Steve Rindsberg wrote: ----

Hello
I have an Excel spreadsheet containing about 800 records. Each record contains a
Click to expand...
first name (column 1), last name (column 2), City (column 3) and State (column 4).
Each record will appear on a PowerPoint frame (this is for an awards ceremony). I
am not a programmer, but would like to somehow automate the importing of this data
into PowerPoint. In looking through the posts here, Bill Dilworth's post on 3/12
seemed to be a start in the right direction, but I could not get it to work. Any
ideas


Another approach: http://merge.pptools.co
(it's an inexpensive commercial addin; free demo available

-
Steve Rindsberg, PPT MV
PPT FAQ: www.pptfaq.co
PPTools: www.pptools.co
 
Back
Top