Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Problem with that PPT changes an objects number during macro in aloop

Hi,

I have an issue with a macro which creates automatic slides for me in
PPT. The data is taken from excel and then put in the corresponding
place (object) in PPT. However, after having looped exactly 42 times,
the object which is being pasted to (I have one file which is the
source file that is opened and manipulated with the data over and over
again and saved everytime depending on the analysed firms name)
changes number from 292 to 293, and if I click it again it changes to
294 etc... So for the first 42 times the object continues to be "group
292" but on the 43 rd time, it becomes "group 293", any suggestions as
to why this is and how to solve it?

The code used is:

Rectangle = "Group 292"
oPPTApp.ActiveWindow.Selection.SlideRange.Shapes(R ectangle).Select

Best regards,

Peder
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
insert objects problem ARGT Excel Discussion (Misc queries) 1 July 21st 08 12:28 PM
Number of UserForm Control Objects IT_roofer Excel Programming 14 June 12th 07 08:36 PM
Run aloop using a list answer33 Excel Programming 3 May 7th 07 08:39 PM
Help - Cannot shift objects off sheet problem sedelson@no Excel Discussion (Misc queries) 6 December 29th 04 06:34 PM
Problem with my Unique Number Macro...Help? RPIJG[_16_] Excel Programming 2 May 14th 04 01:38 AM


All times are GMT +1. The time now is 10:21 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"