Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.powerpoint
cl cl is offline
external usenet poster
 
Posts: 1
Default Create/Update Excel Objects in Power Point

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
link Excel / Power Point bbb Excel Discussion (Misc queries) 1 March 7th 06 07:44 PM
pie charting through excel, using power point carver922 New Users to Excel 2 May 10th 05 09:00 PM
Excel VBA with power point? Malcom Jazz[_2_] Excel Programming 2 January 8th 05 01:39 PM
Cant close Excel App from Power Point Dan[_37_] Excel Programming 1 June 23rd 04 10:42 PM


All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"