I have created two set of data in excel which shows the actual vs target, and created a line chart and added it to the power point. I am looking for a macro when ever the actual value reaches or exceeds the target value in the chart the sounds should be played automatically using powerpoint vba. Can some one help me with the code?
Powerpoint VBA to Auto play sounds
- Thread starter Balajisx
- Start date
Kenneth Hobson
Active Member
You have not provided enough information to help. Try making a simple Excel file with the data and the chart and the macro code and upload it.
I am guessing that the code puts the chart into PPT. Explain in the file what would define the limit and how the data would show it was met. Some might do best fit to the data and predict but you may want an actual segment check. depending on data, that may be when some Y value >= target/goal value.
If the goal is to just play a sound file in PPT, since you are in Excel anyway, why not play it there? What you may want is that when the PPT file is save and then opened to that slide with the chart, an embedded sound file would play?
Click the Upload a File button in bottom right of a reply to upload the file.
I am guessing that the code puts the chart into PPT. Explain in the file what would define the limit and how the data would show it was met. Some might do best fit to the data and predict but you may want an actual segment check. depending on data, that may be when some Y value >= target/goal value.
If the goal is to just play a sound file in PPT, since you are in Excel anyway, why not play it there? What you may want is that when the PPT file is save and then opened to that slide with the chart, an embedded sound file would play?
Click the Upload a File button in bottom right of a reply to upload the file.