+ Reply to Thread
Results 1 to 4 of 4

Linking PowerPoint with Excel via VBA

  1. #1
    Registered User
    Join Date
    10-11-2011
    Location
    London
    MS-Off Ver
    Excel 20010
    Posts
    10

    Linking PowerPoint with Excel via VBA

    Hello helpful people,

    I am currently working on a project where I have a master excel sheet which will be the source of data for several reports. These reports ultimately need to be in Powerpoint. I have set up a template ppt. file and created the excel sheets but I was wondering if there was a way of simply having a button which would open Powerpoint and transfer the relevant data across using linked cells and graphs?

    I understand how to link cells and record basic macros but VBA is a whole new ball game for me.

    Any words of wisdom would be much appreciated.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Linking PowerPoint with Excel via VBA

    This can be done and requires a reference to the PowerPoint object library to be made in Excel.

    The easiest way to get to the endpoint is to create the macro in PowerPoint itself entering the data manually and then copy the macro code into Excel and prefix each object in the PP code with the PP application.

    It's a bit difficult to explain in a simple reply but you might be able to find some examples out there that do this. If not, please come back here.
    Martin

  3. #3
    Registered User
    Join Date
    10-11-2011
    Location
    London
    MS-Off Ver
    Excel 20010
    Posts
    10

    Re: Linking PowerPoint with Excel via VBA

    Cheers for your reply Martin. Do you happen to have any examples or links that I could look at to understand how to write a macro in powerpoint 2010?

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Linking PowerPoint with Excel via VBA

    Sorry for the delay in replying.

    Please see the attachment.

    The code is in Module1. I have made a reference to the PowerPoint object model using Tools-References in the VBA editor.

    Hope this gets you started.
    Attached Files Attached Files

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1