A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Importing List of Words from Excel to PP



 
 
Thread Tools Display Modes
  #1  
Old August 24th, 2004, 01:45 AM
Kitty
external usenet poster
 
Posts: n/a
Default Importing List of Words from Excel to PP

Hi!
I am a teacher and have a list in Excel of 225 "sight"
words. I would like to import these words into a power
point presentation with one word per slide so the kids
can have electronic flash cards. Is there a way to do
this without retyping each word?

Thanks.
  #2  
Old August 24th, 2004, 02:04 AM
Kathy J
external usenet poster
 
Posts: n/a
Default

Kitty,
Save your Excel file as a text file, with each word on an independent line.
Open PowerPoint and do File-- Open. Change the type to All Outlines and
navigate to where you saved the file. Each word should end up on its own
slide in the title placeholder. Format the presentation as you want. (You
can even add pictures to the slides to show what the words mean.)

How's that for sneaky fixes? Quick, easy, and no hassle!

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint answers at http://www.powerpointanswers.com
Featured Presenter at PPT 2004 - http://www.pptlive.com
Need to learn about advanced PowerPoint Animations? Check out:
http://www.eclecticacademy.com/newclasses.htm#pptanim

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

"Kitty" wrote in message
...
Hi!
I am a teacher and have a list in Excel of 225 "sight"
words. I would like to import these words into a power
point presentation with one word per slide so the kids
can have electronic flash cards. Is there a way to do
this without retyping each word?

Thanks.



  #3  
Old August 24th, 2004, 04:37 AM
Steve Rindsberg
external usenet poster
 
Posts: n/a
Default

In article , Kathy J wrote:
Kitty,
Save your Excel file as a text file, with each word on an independent line.
Open PowerPoint and do File-- Open. Change the type to All Outlines and
navigate to where you saved the file. Each word should end up on its own
slide in the title placeholder. Format the presentation as you want. (You
can even add pictures to the slides to show what the words mean.)

How's that for sneaky fixes? Quick, easy, and no hassle!


One wrinkle ... might need to bust the text file into two parts. I think PPT
may limit you to adding 100 slides this way.

Once you have both converted to PPT, Insert, Slides, From File should merge the
two.


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

  #4  
Old August 24th, 2004, 04:57 AM
Kathy J
external usenet poster
 
Posts: n/a
Default

Steve,
I don't think the file needs to be split - I've just tested it with over 400
copy and pasted words in a list and it worked just fine. Want me to send you
the text file so that you can test it?

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint answers at http://www.powerpointanswers.com
Featured Presenter at PPT 2004 - http://www.pptlive.com
Need to learn about advanced PowerPoint Animations? Check out:
http://www.eclecticacademy.com/newclasses.htm#pptanim

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

"Steve Rindsberg" wrote in message
...
In article , Kathy J wrote:
Kitty,
Save your Excel file as a text file, with each word on an independent

line.
Open PowerPoint and do File-- Open. Change the type to All Outlines and
navigate to where you saved the file. Each word should end up on its own
slide in the title placeholder. Format the presentation as you want.

(You
can even add pictures to the slides to show what the words mean.)

How's that for sneaky fixes? Quick, easy, and no hassle!


One wrinkle ... might need to bust the text file into two parts. I think

PPT
may limit you to adding 100 slides this way.

Once you have both converted to PPT, Insert, Slides, From File should

merge the
two.


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================



  #5  
Old August 24th, 2004, 01:42 PM
Geetesh Bajaj
external usenet poster
 
Posts: n/a
Default

Kathy, thank you for allowing me to post the technique he

http://www.indezine.com/notes/2004/0...-in-excel.html


--
Geetesh Bajaj, Microsoft PowerPoint MVP
PowerPoint Notes: http://www.indezine.com/notes
Free Templates:
http://www.indezine.com/powerpoint/t...templates.html

Technical Specialist, PowerPoint Live
http://www.powerpointlive.com



"Kathy J" wrote in message
...
Steve,
I don't think the file needs to be split - I've just tested it with over

400
copy and pasted words in a list and it worked just fine. Want me to send

you
the text file so that you can test it?

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro!

Books
Get PowerPoint answers at http://www.powerpointanswers.com
Featured Presenter at PPT 2004 - http://www.pptlive.com
Need to learn about advanced PowerPoint Animations? Check out:
http://www.eclecticacademy.com/newclasses.htm#pptanim

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we

lived

"Steve Rindsberg" wrote in message
...
In article , Kathy J wrote:
Kitty,
Save your Excel file as a text file, with each word on an independent

line.
Open PowerPoint and do File-- Open. Change the type to All Outlines

and
navigate to where you saved the file. Each word should end up on its

own
slide in the title placeholder. Format the presentation as you want.

(You
can even add pictures to the slides to show what the words mean.)

How's that for sneaky fixes? Quick, easy, and no hassle!


One wrinkle ... might need to bust the text file into two parts. I

think
PPT
may limit you to adding 100 slides this way.

Once you have both converted to PPT, Insert, Slides, From File should

merge the
two.


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================





  #6  
Old August 24th, 2004, 05:30 PM
Steve Rindsberg
external usenet poster
 
Posts: n/a
Default

In article , Kathy J wrote:
Steve,
I don't think the file needs to be split - I've just tested it with over 400
copy and pasted words in a list and it worked just fine. Want me to send you
the text file so that you can test it?


It may be version-dependent. If you say it works, it works. In which version?
g

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

  #7  
Old August 24th, 2004, 06:24 PM
Kathy J
external usenet poster
 
Posts: n/a
Default

2003 - You want me to check it on the other ones? I'll do it later
today....

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint answers at http://www.powerpointanswers.com
Featured Presenter at PPT 2004 - http://www.pptlive.com
Need to learn about advanced PowerPoint Animations? Check out:
http://www.eclecticacademy.com/newclasses.htm#pptanim

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

"Steve Rindsberg" wrote in message
...
In article , Kathy J wrote:
Steve,
I don't think the file needs to be split - I've just tested it with over

400
copy and pasted words in a list and it worked just fine. Want me to send

you
the text file so that you can test it?


It may be version-dependent. If you say it works, it works. In which

version?
g

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================



  #8  
Old August 24th, 2004, 06:26 PM
Geetesh Bajaj
external usenet poster
 
Posts: n/a
Default

Steve, I tried 400 words in PowerPoint 2000 and 2003 and it worked.

However, I have not tried 400 titles with different indents - also no
variations in form from slide to slide were used since all slides only
included a title.

Also, I don't have PowerPoint 97 installed to test - anyone with PowerPoint
97 installed?

--
Geetesh Bajaj, Microsoft PowerPoint MVP
PowerPoint Notes: http://www.indezine.com/notes
Free Templates:
http://www.indezine.com/powerpoint/t...templates.html

Technical Specialist, PowerPoint Live
http://www.powerpointlive.com




"Steve Rindsberg" wrote in message
...
In article , Kathy J wrote:
Steve,
I don't think the file needs to be split - I've just tested it with over

400
copy and pasted words in a list and it worked just fine. Want me to send

you
the text file so that you can test it?


It may be version-dependent. If you say it works, it works. In which

version?
g

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================



  #9  
Old August 24th, 2004, 07:20 PM
Steve Rindsberg
external usenet poster
 
Posts: n/a
Default

Thanks for checking, Geetesh/Kathy.

Firing up a box with 97 installed right now. Hang on ...

Nope. I must be remembering that limit from an earlier version of PPT than 97.

97 blipped a 400 line text file into slides in nothing flat.


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

  #10  
Old August 24th, 2004, 08:48 PM
Kathy J
external usenet poster
 
Posts: n/a
Default

Thanks for checking. I didn't think it would fail on the earlier versions,
since it is based on an ancient tip of yours, but wasn't positive.

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint answers at http://www.powerpointanswers.com
Featured Presenter at PPT 2004 - http://www.pptlive.com
Need to learn about advanced PowerPoint Animations? Check out:
http://www.eclecticacademy.com/newclasses.htm#pptanim

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

"Steve Rindsberg" wrote in message
...
Thanks for checking, Geetesh/Kathy.

Firing up a box with 97 installed right now. Hang on ...

Nope. I must be remembering that limit from an earlier version of PPT

than 97.

97 blipped a 400 line text file into slides in nothing flat.


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Contacts From Excel to a Distribution List SJT General Discussion 0 August 19th, 2004 06:31 PM
synchronizing form and list box Deb Smith Using Forms 8 June 21st, 2004 08:15 PM
Coverting Lotus 123 files to use with excel Muffin1947 General Discussion 6 June 20th, 2004 10:18 AM
Excel Data List - why does it delete the data below the list? ryanlillywhite General Discussion 1 June 14th, 2004 06:56 PM
Autofilter/filter in Excel only shows 1000 rows in dropdown list. Sven Stian Worksheet Functions 2 March 25th, 2004 08:07 AM


All times are GMT +1. The time now is 02:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.