Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Location
    London
    Posts
    64

    Unanswered: Excel To Powerpoint

    Good afternoon everyone,

    I am having a few problems controlling Powerpoint via Excel VBA. I think what im trying to do is fairly simple.

    I have a report that gets produced in Powerpoint. This report contains loads of linked graphs and tables. There are also some textboxes with dates etc that need to be updated each time the report is run.

    The problem i am having is how to identify the names of the controls on the PP slide so i can control them from excel. I cant for the life of me find any adequate properties that give me the name i need to refer my code to.

    I have a (variable ridden) sample of code written by an ex employee, so i have the code to open, refresh and update the graphs and text boxes but of course i dont know which text boxes to refer to.

    Any advice/help would be greatly appreciated.

    Thanks

    EddiesVoicebox

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. Try this link to get some answers.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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