+ 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
    4

    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
    Valued Forum Contributor
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,486

    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
    4

    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)

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