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

Howdy. Try this link to get some answers.