Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
insert objects problem | Excel Discussion (Misc queries) | |||
Number of UserForm Control Objects | Excel Programming | |||
Run aloop using a list | Excel Programming | |||
Help - Cannot shift objects off sheet problem | Excel Discussion (Misc queries) | |||
Problem with my Unique Number Macro...Help? | Excel Programming |