+ Reply to Thread
Results 1 to 13 of 13

Exporting Excel Data in Powerpoint presentation

  1. 12-18-2006, 11:36 AM #1
    Petitboeuf
    Petitboeuf is offline
    Registered User
    Join Date
    06-14-2004
    Posts
    75

    Question Exporting Excel Data in Powerpoint presentation

    Hiya Experts!

    I would like to create a Powerpoint presentation template with some buttons on one page that allow the user to click and fetch the relevant data from an excel workbook based on the button.

    I tried to record a macro from Powerpoint to discover that it didn’t record any interaction between the two!

    I have surfed various forums and haven’t been able to locate code that could help…

    Would any of you have any idea on how to go about doing this? Where should the code sit? VBA Powerpoint? VBA Excel?

    Many thanks!
    Reply With QuoteRegister To Reply
  2. 12-18-2006, 11:50 AM #2
    Carim
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    An example of a Powepoint macro which updates Excel links ...

    Please Login or Register  to view this content.
    HTH
    Carim
    Reply With QuoteRegister To Reply
  3. 12-19-2006, 03:33 AM #3
    ssrirao
    ssrirao is offline
    Registered User
    Join Date
    12-19-2006
    Posts
    15
    hi, even i have the same problem....
    i pasted the above code in the button macro....
    but the excel sheet give the message 'select destination and press ENTER or choose Paste', when i click on the button (which contains the above code).
    Microsoft Excel 2002 - SP3
    Reply With QuoteRegister To Reply
  4. 12-19-2006, 06:20 AM #4
    Petitboeuf
    Petitboeuf is offline
    Registered User
    Join Date
    06-14-2004
    Posts
    75
    Hi
    Same here - just want to when clicking on the button go to Excel, copy the selected area and paste link within Powerpoint creating a new slide...

    Should be easy LOL
    Reply With QuoteRegister To Reply
  5. 12-19-2006, 08:17 AM #5
    ssrirao
    ssrirao is offline
    Registered User
    Join Date
    12-19-2006
    Posts
    15
    hi, Let me state the problem clearly....
    I)
    I have
    1) an excel sheet with data from a1 to L60...
    Note: The format of each cells are different....
    2) a button

    II)
    What i want
    1) When i click on button the system should open a ppt containing the excel data on it....i.e. data from a1 to L60.....

    III)
    Problem I am facing....
    1) The system automatically opens the ppt, but the data gets pasted outside the workarea of PPT!


    Which code i have to use under the excel button in order to get a proper(formatted) powerpoint output?....
    Last edited by ssrirao; 12-19-2006 at 08:20 AM.
    Reply With QuoteRegister To Reply
  6. 12-19-2006, 09:15 AM #6
    Petitboeuf
    Petitboeuf is offline
    Registered User
    Join Date
    06-14-2004
    Posts
    75
    Ssrirao - I have no idea!

    My original post was for that very reason.

    Except that i want to work from a powerpoint presentation and go fetch Excel data when clicking on a button on one slide.

    What i have is a Powerpoint presentation with circa 20 slides. On one slide there are buttons with customers.
    When the button for Customer A is clicked, the macro should:
    • Read the XL workbook
    • Find the relevant data (as pointed towards with code)
    • Copy the relevant pre-formatted XL data
    • Create a new slide in the powerpoint presentation
    • Past link the XL data

    I think this could be possible but i just have no idea how...
    Reply With QuoteRegister To Reply
  7. 12-19-2006, 10:48 AM #7
    Carim
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    To EXPORT data from Excel to Powerpoint ...

    Please Login or Register  to view this content.
    HTH
    Carim
    Reply With QuoteRegister To Reply
  8. 12-20-2006, 09:49 AM #8
    Petitboeuf
    Petitboeuf is offline
    Registered User
    Join Date
    06-14-2004
    Posts
    75
    Carim - Thanks for that!

    However i want to IMPORT data into Powerpoint, running the macro from Powerpoint.

    Is that possible?
    Reply With QuoteRegister To Reply
  9. 12-20-2006, 10:03 AM #9
    Carim
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Yes ... it is possible ... but since we are in an Excel forum, I am just going to give you a link ...
    http://www.pptfaq.com/FAQ00593.htm

    HTH
    Carim
    Reply With QuoteRegister To Reply
  10. 12-21-2006, 05:22 AM #10
    ssrirao
    ssrirao is offline
    Registered User
    Join Date
    12-19-2006
    Posts
    15
    hi, i got the message 'Application (unknown member) : Invalid request. There is no active presentation' when called the RangeToPresentation() from button.

    but works fine when a blank powerpoint presentation is kept open.

    still i have problem in formatting..the data gets pasted outside the side also (i.e. outside the ppt work area)
    Last edited by ssrirao; 12-21-2006 at 05:33 AM.
    Reply With QuoteRegister To Reply
  11. 12-21-2006, 05:37 AM #11
    Bryan Hessey
    Bryan Hessey is offline
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by ssrirao
    hi, i got the message 'Application (unknown member) : Invalid request. There is no active presentation' when called the RangeToPresentation() from button.

    but works fine when a blank powerpoint presentation is kept open.

    still i have problem in formatting..the data gets pasted outside the side also (i.e. outside the ppt work area)
    Hi,
    the 'presentation' looks like a PPT question, there is a powerpoint group at http://www.microsoft.com/office/comm...&lang=en&cr=US which might be able to resolve that for you if that is the case.

    hth
    ---
    Si fractum non sit, noli id reficere.
    Reply With QuoteRegister To Reply
  12. 12-21-2006, 08:50 AM #12
    vikas.bhandari
    vikas.bhandari is offline
    Forum Contributor vikas.bhandari's Avatar
    Join Date
    04-07-2006
    Location
    Delhi, India
    MS-Off Ver
    Office 2007 and 2010
    Posts
    303

    Thumbs up Bingo, Use Paste Link

    A simple Solution without a macro.....

    Open the excel File, and Copy the data which you want to import!!! Open the ppt presentation and insert a chart. Right click on the Char and go to

    Chart Object-->Open. Delete the existing Values and then go to edit and click on Paste Link!!!

    Going forward, each time you will choose the open option through the chart object, it will automatically refresh the chart with the new values in the Excel.

    Try it once...I found it easier
    Reply With QuoteRegister To Reply
  13. 12-22-2006, 06:28 AM #13
    Petitboeuf
    Petitboeuf is offline
    Registered User
    Join Date
    06-14-2004
    Posts
    75
    Thanks for the link Carim.

    I was after some VBA code not specific to either Excel or Powerpoint... or so i thought!

    I'll do some more digging then to try to find specific Powerpoint coding tutorials and forums.

    Thanks again and sorry for the confusion!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1