+ Reply to Thread
Results 1 to 4 of 4

Excel Cells in to PowerPoint

  1. #1
    Forum Contributor
    Join Date
    12-18-2012
    Location
    Sweden
    MS-Off Ver
    Office 2016
    Posts
    158

    Excel Cells in to PowerPoint

    Hi!

    I am trying to get a VBA script which will allow me to click a button in my Excel sheet and sit back and enjoy the 3 second show!

    What im after is the following:

    In Cells B2:F14 I have a bunch of data in a specific order. When i click my Macrobutton in Excel I want Excel to open up Powerpoint, load the predetermined slideshow and page in the predetermined slideshow and paste the data (Cell format, size etc included) into the page.

    Is this possible in a simple way?

    Thank you in advance!

  2. #2
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Excel Cells in to PowerPoint

    Check below

    Please Login or Register  to view this content.
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html

  3. #3
    Forum Contributor
    Join Date
    12-18-2012
    Location
    Sweden
    MS-Off Ver
    Office 2016
    Posts
    158

    Re: Excel Cells in to PowerPoint

    Hi!

    This seems to do the first part great and im getting it to work. However it creates a new Powerpoint presentation each time. Is there a way that I can point it to a directory and my Powerpoint slide (Lets say my slide is in (C:\PowerPointFiles\ExcelForumSlide1). And when this file opens paste the Excelinformation into slide number 2 (If I remember correctly PP names their slides "SLIDE#" if no other name is manually entered?). Preferably by removing the old Excelinformation before pasting the new so its not just 400 pictures on top of eachother after a while.

    Am I making sense here?

    Thank you in advance!

  4. #4
    Forum Contributor
    Join Date
    12-18-2012
    Location
    Sweden
    MS-Off Ver
    Office 2016
    Posts
    158

    Re: Excel Cells in to PowerPoint

    I am going to be bold enough to bump this post once before I accept defeat and assume that there is no solution to what I wish to do. My Programming course doesnt start until late fall so it'll be quite a while before I can get the hang of this stuff myself sadly

    Well, here's to hoping!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 VBA code to close powerpoint slide show, but not powerpoint application
    By christopher@groth.cc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-18-2015, 06:39 AM
  2. Excel/PowerPoint VBA teaser: How to change data labels in PowerPoint chart by VBA?
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 11:47 AM
  3. Exporting text from powerpoint presentation into excel cells
    By soultrappa in forum PowerPoint Formatting & General
    Replies: 0
    Last Post: 12-09-2014, 08:38 AM
  4. VBA Transfer Range from Excel to Powerpoint (New or Existing Powerpoint Presentation)
    By ThePeoplesClub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2014, 02:52 PM
  5. Replies: 13
    Last Post: 01-11-2013, 04:46 PM
  6. Replies: 2
    Last Post: 01-06-2011, 07:35 PM
  7. Replies: 0
    Last Post: 07-18-2006, 04:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1