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? I am thinking maybe I need to create a templatefile instead of a normal PPT presentation file used as template? 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 | |||
Looping a macro x times(x being activecell.value)? | Excel Programming | |||
How to run a Macro specified number of times? | Excel Programming | |||
Looping Macro with input boxes all related to one number | Excel Programming | |||
Looping Macro for fixed number of rows | Excel Programming | |||
Run Macro from another X number of times | Excel Programming |