Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.powerpoint
|
|||
|
|||
![]()
I developed an add-in in Power Point 97, 2000, XP and 2003 for creating
Excel charts/tables and being able to update them. The code I used is below: Dim PPT_CHRT As OLEFormat Dim PPT_SLD As Slide 'ADD a chart/table PPT_SLD.Shapes.AddOLEObject Left:=var_chrt_L, Top:=var_chrt_T, Width:=var_chrt_W, Height:=var_chrt_H, ClassName:="Excel.Chart.8", Link:=msoFalse Set PPT_CHRT = PPT_SLD.Shapes(var_SHP_count_no).OLEFormat PPT_SLD.Shapes(var_SHP_count_no).Select 'EDIT chart/table Set PPT_SLD = ActivePresentation.Slides(var_SHP_SLD_no) Set PPT_CHRT = PPT_SLD.Shapes(var_CURR_SHAPE_name).OLEFormat PPT_SLD.Shapes(var_CURR_SHAPE_name).Select 'CLOSE chart/table PPT_CHRT.Activate ActiveWindow.Selection.Unselect Set PPT_CHRT = Nothing In 97, 2000 and XP it works without any problem. In 2003, if user selects to update a lot of charts/tables then messages of Excel start appearing "Microsoft Office Excel starts recovering your documents" and errors appear when I use the objects for editing a chart/table. What could be the problem ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
link Excel / Power Point | Excel Discussion (Misc queries) | |||
pie charting through excel, using power point | New Users to Excel | |||
Excel VBA with power point? | Excel Programming | |||
Cant close Excel App from Power Point | Excel Programming |