Results 1 to 6 of 6
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Create PPT Slide from Excel (Excel 2003)

    I have a detailed Excel workbook that tracks my team's projects (subject, dates, owner, status, etc.) and I would like to see if I can automate creating PPT slides from the data (a group of rows or a named range). The PPT is meant to show project overviews and the Excel file stores the details of each item. All meetings here are done in PowerPoint so I have to use that as the reporting format.

    Right now it's a manual effort to create the slides and then I add links to the Excel file to jump back/forth from PPT when a viewer wants to see an item's details. This works but ideally I'd like to automate this whereby from Excel I'd write VBA that creats a slide (from a master that we all use). I know Excel VBA pretty well but haven't looked into PPT's object model at all for automation. If I could somehow create a slide and add bulleted text for 'n' items, then create another slide for the next 'n' items, that'd be perfect.

    Is this in any way possible to do? Where would I start?

    Thnx,
    Deb

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Create PPT Slide from Excel (Excel 2003)

    PowerPoint VBA is limited and frustrating (in my opinion).

    Word has a pretty good File | Send To | Microsoft PowerPoint option that converts a Word outline into a PowerPoint presentation. Any chance you can create a Word document with Heading styles from your Excel workbook?

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create PPT Slide from Excel (Excel 2003)

    Yes I agree but I know Excel and the data is already in that format and wide tables are so much easier in Excel than Word. However, just now I played with PPT and see that if I create a .txt file with one name per row that it automatically creates one slide per row (with the slide title being the row text). So a text file with names "Joe, Ruth, Jack" one per line, creates three slides titled Joe, Ruth, Joe, respectively. This looks promising. I saw this from the menu Insert/Slides_From_Files and experimented. I can't get it (yet) to create the bulleted text from this .txt file but maybe there is some syntax in the text file that tell is to use the text as a bullet item and not slide title.

    I then recorded a PPT macro to add bulleted items and that worked fine so if I can figure out how to open PPT from Excel maybe I can use that code as a basis to write some of the Excel cells as bullet items in a PPT slide. It'd select some set of cells and use one as a title and 'n' other cells as bulleted items on that slide.

    <pre>Dim obPPT as Object
    Set obPPT = CreateObject("PowerPoint")</pre>

    doesn't work.

    Deb

  4. #4
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create PPT Slide from Excel (Excel 2003)

    Actually, if I can't get this to work directly from Excel maybe I can use your suggestion and use Word as the intermediary. I'd have to create a .doc from Excel, write the data I want as headings and save it (temporarily). Then I'd open an instance of PPT from Excel and do the Insert/From Outline feature.

    Deb

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Create PPT Slide from Excel (Excel 2003)

    If you want to automate PowerPoint from Excel, it's best to set a reference in Tools | References to the Microsoft PowerPoint 11.0 Object Library. You can then use IntelliSense. The following instruction declares and starts a PowerPoint application object.

    Dim obPPT As New PowerPoint.Application

    Alternatively:

    Dim obPPT As PowerPoint.Application
    Set obPPT = CreateObject("PowerPoint.Application")

  6. #6
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create PPT Slide from Excel (Excel 2003)

    Ahh, no wonder I couldn't find it. <img src=/S/bash.gif border=0 alt=bash width=35 height=39> I already had a reference to Microsoft Office 11.0 Object Library and figured that was enough for PPT but apparently not. Everyone here has the same version of Office with PPT installed so that reference should be ok. I'll play with what I have and see if I can get it to work well enough. I'll post a sample if I get it done. I don't need any fancy formatting, if I can create a slide with title and bullets from a range of cells that'd be 100% better than what I do now. <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

    Thnx,
    Deb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •