Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a Powerpoint slide with an embedded chart that I want to change the
values in (from Excel). Typing ?ppslide.shapes(2).Name in the immediate window gives me the object Object 2933, and I can select it, but I do not know the syntax to reference the specific object cells A1:J1 Which methods and properties will get me to my end goal? Thanks in advance. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Two ways:
If your Excel source document is open, you can double click on the embedded chart to activate it. See help in Power Point for Embedded Excel Charts. If you don't care about updating your source file in Excel, you can update the chart as a drawing object by clicking, draw ungroup do an edit then regroup. See Power Point help file for Changing Embedded Charts without Opening Source File. "MVP Wannabe" wrote: I have a Powerpoint slide with an embedded chart that I want to change the values in (from Excel). Typing ?ppslide.shapes(2).Name in the immediate window gives me the object Object 2933, and I can select it, but I do not know the syntax to reference the specific object cells A1:J1 Which methods and properties will get me to my end goal? Thanks in advance. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Disregard that last message. You are looking for code to make the change and
I have not tried that myself. "MVP Wannabe" wrote: I have a Powerpoint slide with an embedded chart that I want to change the values in (from Excel). Typing ?ppslide.shapes(2).Name in the immediate window gives me the object Object 2933, and I can select it, but I do not know the syntax to reference the specific object cells A1:J1 Which methods and properties will get me to my end goal? Thanks in advance. |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You might get some ideas from this site:
http://peltiertech.com/Excel/XL_PPT.html "MVP Wannabe" wrote: I have a Powerpoint slide with an embedded chart that I want to change the values in (from Excel). Typing ?ppslide.shapes(2).Name in the immediate window gives me the object Object 2933, and I can select it, but I do not know the syntax to reference the specific object cells A1:J1 Which methods and properties will get me to my end goal? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
updating embedded powerpoint in excel file | Excel Discussion (Misc queries) | |||
Problem in updating the Powerpoint Embedded Chart with Excel figur | Charts and Charting in Excel | |||
In copied worksheet, embedded chart uses data fm orig - change? | Charts and Charting in Excel | |||
Linked cells as embedded in PowerPoint | Excel Discussion (Misc queries) | |||
Embedded chart along with DATA to powerpoint | Excel Programming |