+ Reply to Thread
Results 1 to 3 of 3

Referring to an embedded excel worksheet in powerpoint

  1. #1
    Registered User
    Join Date
    04-02-2017
    Location
    Kiel, Germany
    MS-Off Ver
    2010
    Posts
    6

    Referring to an embedded excel worksheet in powerpoint

    Hi Guys,

    I searched in the net and found some similar cases, but they couldn't help me much.

    I have an embeded Excel Worksheet in Powerpoint. I want to automatically save the Powerpoint Presentation as a PDF file, using a button with a Macro.The name of the PDF file should include a number from a particular cell in the Excel Worksheet. I added a button (on the menu taskbar) with a Macro, that automaticaly saves the Powerpoint as a PDF. Do you know, how can I refer to the cell in the Excel Worksheet in order to use it for the name of the PDF?

    Many thanks for your help in advance!

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Referring to an embedded excel worksheet in powerpoint

    Hi
    assuming there is a single excel spreadsheet embedded on the first slide of your presentation, this should return the contents of cell A1. You can tweak the references as necessary..

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-02-2017
    Location
    Kiel, Germany
    MS-Off Ver
    2010
    Posts
    6

    Re: Referring to an embedded excel worksheet in powerpoint

    Awesome! It works perfectly! Thank you very much NickyC!

+ 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. [SOLVED] Convert Embedded PowerPoint Chart to Excel
    By deturnbull in forum Excel General
    Replies: 9
    Last Post: 03-27-2022, 11:33 AM
  2. Breaking links to embedded excel sheets in PowerPoint
    By cffndncr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2015, 03:08 AM
  3. Interactive Excel Workbook / Embedded Powerpoint Presentation
    By hamzahs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-25-2013, 09:27 AM
  4. Update embedded excel containing sql in powerpoint
    By DeNam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2013, 08:23 AM
  5. manipulate embedded excel workbook in Powerpoint
    By kayvon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2012, 03:06 PM
  6. Embedded chart in Powerpoint to Excel
    By JWoodrell in forum Excel General
    Replies: 0
    Last Post: 01-20-2012, 02:43 PM
  7. Locking access to embedded Excel files from within Powerpoint
    By dylanemcgregor in forum Excel General
    Replies: 2
    Last Post: 09-24-2009, 02:48 PM

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